what is a junk dimension ?
- 14 Answers
- 60124 Views
- Atos Origin, Cognizant, HS, NIIT, TCS, I also Faced
- E-Mail Answers
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 is flashback table ? Advance thanks
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
How to configure mapping in informatica?
Quickly characterize reusable change?
What is the cumulative sum and moving sum?
What is incremental aggregation?
What is the scenario which compels informatica server to reject files?
Is it possible to create multiple domains on a single Informatica server?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
Differentiate between Load Manager and DTM?
what is the difference between informatica6.1 and infomatica7.1
expain about the tune parameters?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
Which is the t/r that builts only single cache memory?
What is source qualifier transformation in informatica?
