Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a scenario, wherein I have around 10 excel dumps, for each month, of which 4 groups can be clubbed according to there simlilar nature of calculation.
Ex. Table A, A1 , B,B1,B2 , C,C1,C3, D,D1.
All of these dumps have 90% simlar fields in them.
Current Data Model as best I could think of, I have calculated individual dump accordingly, Grouped and stored into respective group QVDs.
Now, I have concatenated these QVDs.
But the issue is the Load,becoz of this the application size has increased 300000 KB !!!
Please suggest on how to create the data Model in this scenario.
Thanks in advance !
Go to this link
try joining if required
--Analyse the complete association of fields and keys.
---minimise number of qvd
---at last try to break the model with fact and dimension table