what is a junk dimension ?
Answer Posted / aparna
A junk dimension is a convenient grouping of flags and
indicators. It's helpful, but not absolutely
required, if there's a positive correlation among the
values. The benefits of a junk dimension
include: ? Provide a recognizable, user-intuitive location
for related codes, indicators and their
descriptors in a dimensional framework.
? Clean up a cluttered design that already has too many
dimensions. There might be five
or more indicators that could be collapsed into a single 4-
byte integer surrogate key in
the fact table.
? Provide a smaller, quicker point of entry for queries
compared to performance from
constraining directly on these attributes in the fact
table. If your database supports bitmapped
indices, this potential benefit may be irrelevant, although
the others are still
valid.
Is This Answer Correct ? | 20 Yes | 3 No |
Post New Answer View All Answers
Enlist the advantages of informatica.
What are the prerequisite tasks to achieve the session partition?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
what is mean by complex business rule ?
What are the informatica performance improvement tips
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
Why is sorter an active transformation?
EXL informatica Questions
Explain lookup transformation in informatica
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What are the different types of repositories created using informatica?
What are the tuning techniques you applied during your last project
How can we store previous session logs?
What can we do to improve the performance of informatica aggregator transformation?
Differentiate between sessions and batches?