What are diagrams?
No Answer is Posted For this Question
Be the First to Post Answer
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.
What is edw?
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?
State any 5 of Cods guidelines of an OLAP system, brief description each?
Explain what are the different types of data warehousing?
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?
Why joiner transformation does not allow the aggregator transformation and expression transformation to join
Explain what are the advantages data mining over traditional approaches?
Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?
Explain how to get the first 100 rows from the flat file into the target?
What are fact, dimension, and measure?
How to answer the question how many fakt table in your datawarehouse and what size it have?