what is a junk dimension ?
Answer Posted / vamshi
In data warehouse design, frequently we run into a situation where there are yes/no indicator fields in the source system. However, if u keep all those indicator fields in the fact table, not only do we need to build many small dimension tables, but the amount of information stored in the fact table also increases tremendously,
Junk dimension is the way to solve this problem. In a junk dimension, we combine these indicator fields into a single dimension. This way, we'll only need to build a single dimension table, and the number of fields in the fact table, as well as the size of the fact table, can be decreased
The content in the junk dimension table is the combination of all possible values of the individual indicator fields
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What do think which one is the better joiner or look up?
Explain in detail about scd type 1 through mapping.
Tell me about MD5 functions in informatica
COM components can be used in Informatica
What is the difference between Active and Passive transformation?
What are the differences between source qualifier and joiner transformation?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
In warehouses how many schemas are there?
What is informatica metadata and where is it stored?
Explain direct and indirect flat file loading (source file type) - informatica
Explain how to import oracle sequence into informatica?
What is transformation?
How to do the error handling of if ur source is flatfiles?
what is unit testing?tell me proceedure
What is an expression transformation?