What is the difference between mapping parameter & mapping variable in data warehousing?
How can we schedule the graph in unix?
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?
What is a fact, dimension, measure?
Why denormalization is promoted in universe designing?
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?
Explain what are data marts?
for data loading in oracle, what are conventional loading , what are conventional loading and direct-path loading?
What is Star Schema?
Explain about core dimension, balanced dimension, and dirty dimension?
Where the data cube technology is used?
Hyperion is the one of the tool in data ware house. Its an olap tool. Why you cant display that tool?
Why should you put your data warehouse on a different system than your oltp system?