Greeting Datawarehouse Gurus,
We have data staged into BW from a non-SAP system. The data I am interested in is stored into two DSOs and 3 Master Data objects, with the following row counts:
DSO1 -> 28,000,000 and growing by 25,000 rows daily
DSO2 -> 158,000 rows
MDA -> 4,500,000 rows
MDB -> 3,800.000 rows
MDC -> 1,900,000 rows
I need to get the key figure values from DSO2, but I cannot go directly against the DSO without a large join on DSO1, MDA, MDB, and MDC. DSO1 and MDC each contain an element of data I need to use to extract the correct line of data from DSO2. MDA and MDB are used to connect DSO1 and MDC.
How should I approach my design in terms of initial load and further delta processing. I do not think and infoset will work, as I would need to consistantly join. This may take BW a very long time to process the deltas.
APD with filters and subsequent joins, but again I will need to sift though 28M (and growing) rows daily.
Any thoughts would be greatly appreciated.
Kind Regards,
Alex