What are the steps involved in creating dimensional modeling process?
No Answer is Posted For this Question
Be the First to Post Answer
If I have table T1 and table T2 T1 has 250 cols and 10,000 rows T2 has 2 billion rows and 10 cols Which one would be Fact table and which one would be Dimension table and why ?
3 Answers Extech, Principal Finance,
Explain what is the metadata extension?
What is surrogate key? Where we use it? Explain with examples.
State any 5 of Cods guidelines of an OLAP system, brief description each?
What is cubes?
What is "method/1"?
The same tier?
What are aggregate tables and aggregate fact tables?
What is Molap and Rolap? What is Diff between Them?
Where do we use semi and non additive facts?
How can we run the graph? What is the procedure for that?
How to handle time period attribute for time dependent data?? a.)add time period as a part of pk b.)add time period simply and make it nullablec.)add time period simply and make it not null.