Interested to Buy Any Domain ? << Click Here >> for more details...
what is a junk dimension ?
- 14 Answers
- 63405 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 could be the possible resons of locks by user?
How do you handle two sessions in Informatica
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
How to load data in informatica ?
What can we do to improve the performance of informatica aggregator transformation?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
Name the different lookup cache(s)?
How you prepared reports for OLAP?
What are the differences between joiner transformation and source qualifier transformation?
Implementation methodology
What is the difference between a connected look up and unconnected lookup?
where to store informatica rejected data? How to extract the informatica rejected data?
What is a pre-defined event and user-defined event?
What are the types of caches in lookup?
Write the unconnected lookup syntax?
