what is a junk dimension ?
Answer Posted / prakash m
A convenient grouping of random flags and attributes to get
them out of the fact table
Retain only useful fields
Remove fields that make no sense at all
Remove fields that are inconsistently filled
Remove fields that are of operational interest only
Design similar to demographics; maximum unique
combinations, assign integer key, plug into fact
Create new combination (insert new dimension record) at ETL
run-time
E.g. Yes/No Flags in old retail transaction data
Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What is a standalone command task?
Performance tuning in UNIX for informatica mappings?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
Target increases every day even though no new record was inserted
What could be the possible resons of locks by user?
explain about unit testing? in real time?
How can we delete duplicate rows from flat files?
Explain incremental aggregation in informatica
The question was on time stamp. what is the difference between HH and HH24 when to use when.
expain about the tune parameters?
Explain joiner transformation in informatica
what are 3 tech challenges/ common issues you face?
Make a note of the quantity vaults made in informatica?
How identifying bottlenecks in various components of informatica and resolving them?
Explain in detail about scd type 1 through mapping.