Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
In ODI sde phase dimension and fact stage is independent of each other but still in load plan they r
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 ?
Answers
-
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
0 -
Some of the bits in those SO answers are extremely cringeworthy though :-/
0 -
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.
Charles
0 -
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.
0