Hi
In our solution,we have same header data for many item details
Lets say:(just an example but we have more header details)
Company ID
>Item name
>Quantity
1000--
1000--
1000--
so superuser would like to load all header data using one extractor to one DSO and all item data using one extrcator to one other DSO and then combine them using certain logic while mapping both DSOs to cube.I have few doubts about this.Can anybody share their experience:
1.whats the need for this and how will this help BW ?
2.Once data is in BW (Header data in one DSO and Item data in one DSO),How do we combine them using logic while mapping to cube ?
3.After we combine them,it becomes same again.Then why cannnot we load as one single record from source instead of having two different extractors and use two different DSO?
Thanks alot.