Skip to Content
avatar image
Former Member

Master data attributes and master data text Coming same source

HI Experts,

I am confused on This master data attribute and master data text . I have seen several blogs i understood Both can load simentaneously .

lets take one example

if i am having CUST ID, CUST NAME ,LONG Description ,Language,Country ,Region on same flat we will load data in Target if all the things are in same data source(Flat file)

here country and region i need to take as attribute or Hierarchy?

Can we load master data text and attributes at same time or we need to create two data sources

if anyone could explain steps how to load data of all hierarchy and texts and attributes at single point would be helpful

I know its very basic question from so many days my head was spinning due to lack of clarity .please help me with clarity

Appreciate your response



Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Mar 29, 2016 at 08:56 PM

    Let's take example of 0CUSTOMER. Of you go to RSA1 and InfoProvider tab, you get 3 section below 0CUSTOMER. One Attribute, one Text and one Hierarchy.

    Technically from the same Data Source you would be able to load Attribute and Text provided they are available in the same DataSource.

    If you right click on the attribute portion and create a transformation, you are loading attribute and data will go to /BI0/PCUSTOMER table ( assuming display attribute )

    If you do the same on Texts , it will go to /BI0/TCUSTOMER table .



    Capture.PNG (3.7 kB)
    Add comment
    10|10000 characters needed characters exceeded

    • Yes, you will have two different transformation and two different DTP. Those two DTP can run in parallel.

      But why do you want to do that ? Like if you run one DTP after 10 minutes what problem you are expecting ?