ODS data Load from multiple sources.... Help

60 Views

Hello every one,

I have a situation:

I have a ODS where out of 150 fields 100 are coming from flat files, 30 from other ODSs and 20 are from Master Data Tables (some are attributes of Master Data InfoObjects).

I am thinking i can do the following. Please advise if this is fine or if there is any other way of doing it for better performance e.t.c

1 Load the Flat File Fields based on Flat File DataSource/InfoSource/UpdateRules.

2. Load the other ODS fields/data in the Start Routine of the above Update Rules ???

3. Load the Master Data objects through Master Data InfoSources

Please confirm if i can do this. Also is there any order that i have to maintain for the same..... and finally

When i declare the Masterdata Object (say 0MATERIAL) as one of my data object in the ODS and some the fields as the attributes of this 0MATERIAL, if some one is already loading data into the 0MATERIAL, should i load again or not, because i remember Master Data stores data in separate tables.. ... Please remove my confusion 😊)

All useful answers will be given full points.

Thanks a lot ...