what is a junk dimension ?
- 14 Answers
- 60149 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 Methods For Creating Reusable Transformations?
How can we delete duplicate rows from flat files?
What is target load order?
How can you define user defied event?
how tokens will generate?
Is it possible to create multiple domains on a single Informatica server?
Explain what transformation and how many are there in informatica?
Is stop and abort are same in informatica?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
What is the use of target designer?
How can we remove the duplicates from flat file source?
What are active transformations.
In informatics server which files are created during the session rums?
Explain in detail scd type 2 through mapping.
