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
explain about unit testing? in real time?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
What is source qualifier transformation in informatica?
Partition, what happens if the specified key range is shorter and longer
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Explain direct and indirect flat file loading (source file type) - informatica
What are the differences between a connected lookup and unconnected lookup?
To import the flat file definition into the designer where should the flat file be placed?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
How to create Target definition for flat files?
Explain the etl program with few examples.
What is a joiner transformation and why it is an active one?
Which files are created during the session rums by informatics server?
What are the different options available for update strategy?
How do you manage the Parameter files while migrating your data from one environment to another environment?