Answer Posted / madhu
any yes or no like status is an example for junk dimension
Is This Answer Correct ? | 11 Yes | 8 No |
Post New Answer View All Answers
What is a data warehousing?
What is scd1 , scd2 , scd3?
Difference between PowerPlay transformer and power play reports?
How can we run the graph?
Explain piconet?
what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.
Explain what is the limit to the number of sources and targets you can have in a mapping?
What are the methodologies of data warehousing?
Explain grouped cross tab?
How many clustered indexes can u create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
Explain what is partitioning? What are the types of partitioning?
What are the different ways to represent the loading of dimension tables?
What is the purpose of Dataware Control?
Explain what are fact, dimension, and measure?