Interested to Buy Any Domain ? << Click Here >> for more details...
what is a junk dimension ?
- 14 Answers
- 63333 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 code page?
Design a mapping to load a target table with the following values from the above source?
Under which circumstances, informatica server creates reject files?
Difference between Target-based loading and constraint-based loading?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
Name at least 5 different types of transformations used in mapping design and state the use of each.?
my source is junk data how will u remove that junk data by using unix please any one replay me
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
Define the various join types of joiner transformation?
Partition, what happens if the specified key range is shorter and longer
What is the difference between router and filter?
Briefly define a session task?
How many dimensions are there in informatica?
What is an expression transformation?
