FlatFile extraction

[Former Member]

How do we load the data if a FlatFile consists of both Master and Transaction data?

[former_member496813]

Load the master data first if you want any validation / other attributes to be included.

And always load the master data first separately whenever possible.

But you can do both in single extraction also:

1 ) first create a info source simmilar to the structure of this file

2) create the transfer rules to map this fields to the file datasource

3) then map this flexible info source to masterdata info object 0material (only 1 field in this case) with update rules where we filter only the unique records or any other records for master data for the 0material .

4) then load the master data infopackage and load the masterdata first

5) use the same infosource in upload rules for any other infoprovide to load the data from all fields.

6)Load compleat transaction data into the infoprovider.

I think this should work for the given problem, although not a good way of handling the dataload.

Check this:

Don't forget to see page 1.

Hope it helps..

Edited by: ashok saha on Apr 3, 2008 9:19 PM

[Former Member]

We can use some silly logic for that. But data should be distinguished. Mater data cannot be equal to transaction data. Whichmeans master data should be common and specific which can be used to identify various data elements for business.

If you feel you have master data and transaction data in the same file split that data into two different files and load.

[Former Member]

Hi -

Create two different DataSources in BW one for master data and another one for transactional data, You can extract data from same file for two DataSources .You can use master DataSource for master data update, Transactional DataSource for transactional data update.

I hope it helps you .

Anesh B

[Former Member]

can't we extract both master and transactional data using single data source using flexible update while creating info source

Edited by: sapbi on Apr 3, 2008 9:33 PM

[former_member496813]

No - we can't do that.