in ODI SDE is dependent on source system , dimension and fact stage is independent of each other but still why out of the box load plan run these dim and fact stage in serial ?
Hi,
Decent snippet on this: https://stackoverflow.com/questions/10426923/whats-the-suggested-order-of-extracting-dimension-fact-data#
You also may want to go to the Kimball group blogs, and look around: https://www.kimballgroup.com/2003/01/fact-tables-and-dimension-tables/
Hope it helps!
Charles
Some of the bits in those SO answers are extremely cringeworthy though :-/
Hi Christian. Thanks for the feedback. I thought the second reply in SO was ok, but maybe it isn't as thorough after a second look.
My issue is with this:
"when you load new data, first identify the facts you are interested in to make sure you process and load the minimum amount of data. Then derive your dimensions from those facts, so you populate only dimension values that you actually need"
So you just don't load dimension members - or whole dimensions for that matter - where there are no facts?
Ok and how do you analyze where there were no sales last quarter? People who haven't been contacted by a sales rep in the last months? Etc?
Conceptually and analytically an extremely wrong approach.
