Interested to Buy Any Domain ? << Click Here >> for more details...
what is a junk dimension ?
- 14 Answers
- 62747 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 the use of an aggregator cache file?
When do you use sql override in a lookup transformation?
Explain the shared cache and re-cache?
How to elaborate tracing level?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
Mention a few design and development best practices for informatica?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
How does the aggregator transformation handle null values?
What is joiner transformation in informatica?
Where do we use mapping variables in informatica?
How to do the error handling of if ur source is flatfiles?
Define mapping and session?
What is informatica worklet?
What is decode in informatica?
What are the types of caches in lookup? Explain them.
