Answer Posted / palzkumar
It’s simply a structure that provides a convenient place to
store the junk attributes.
| Is This Answer Correct ? | 13 Yes | 7 No |
Post New Answer View All Answers
What is junk dimension? What is the difference between junk dimension and degenerated dimension?
What is partitioning? What are the types of partitioning?
Explain a mapping, session, worklet, workflow, mapplet?
What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?
Explain what is a cube in data warehousing concept?
Explain the difference between data ware house & data mart?
what are the other factors of the database on which the loading performance depend?
Explain which columns go to the fact table and which columns go the dimension table?
What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
Explain conformed fact?
If two relational tables are connected to sq trans, what are the possible errors it will be thrown?
Can you state some of the innovations throughout history?
Explain normalization?
What is data mart in data warehouse?
Explain what is a three tier data warehouse?