Skip to Content
0
Former Member
Mar 25, 2009 at 02:22 PM

Data warehousing design question

20 Views

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