Question:
Hi guys,
I have three ODSes ODS1, ODS2, ODS3, which get data from three infosources namely 2LIS_11_VAITM, 2LIS_12_VCITM, 2LIS_13_VAHDR. ODS1 feeds data to two other ODSes in second level -- ODSA, and ODSB. When I do init data load from 1st level to second level data targets, it is successful, but the subsequent delta fails. So I thought of discarding the 2nd level ODSes and have an Infoset joining the required ODSes. Is this feasible? Is this a good design? Any other solution for the above scenario without using Infosets? Your inputs are highly appreciated..
Thanks and regards,
_________________
Raj
Have a Nice Day:-)
Answer:
Hi Raj
If Init works and delta fails then it could be a SAP issue.
also if u don't see a need for a 2nd level then its better to avoid it.
check is the 0recordmode is defined properly.
Thanks
AA
Answer:
I would suggest that the design is fundamentally good datawarehouse design. Each of the first level ODS come from different data area and can be reinitialised and extended separately, without a reload required of the others (which may not have all PSA data).
As to why your subsequent deltas fail, I haven't got a clue. I have had a similar design at one client working of a year without problems. As long as the init package is loaded to the 2nd level ODS, deltas should load.
Ken