Which columns go to the fact table and which columns go the dimension table?
No Answer is Posted For this Question
Be the First to Post Answer
Why do we use DSS database for OLAP tools?
What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?
What is a fact table?
What Oracle tools can be used to design and build a W/H?
What is the difference between OLAP, ROLAP, MOLAP and HOLAP?
What is Conceptual, Logical and Physical model?
What is Star Schema?
What is bi?
How many project sources we can create in metadata?
What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?
Explain functional dependency?
what is user variable in affinium campaign? and some real time examples.