Interested to Buy Any Domain ? << Click Here >> for more details...
what is a junk dimension ?
- 14 Answers
- 63820 Views
- Atos Origin, Cognizant, HS, NIIT, TCS, I also Faced
- E-Mail Answers
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
What are the advantages of using informatica as an etl tool over teradata?
Is it possible to create multiple domains on a single Informatica server?
What do you mean by worklet?
How do you load alternate records into different tables through mapping flow?
Define mapplet?
What is a surrogate key?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
Explain your project of banking domian.
What is session task and command task?
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 rank transformation in informatica
Repository user profiles
Which files are created during the session rums by informatics server?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
tell me about your project functionality
