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
Explain the informatica workflow?
expain about the tune parameters?
What do you mean incremental aggregation?
According to his methodology what all you need before you build a datawarehouse
Write the unconnected lookup syntax and how to return more than one column.
What is difference between a gateway node and worker node?
What is the difference between stop and abort in informatica
What are the types of caches in lookup?
How can a transformation be made reusable?
Does an informatica transformation support only aggregate expressions?
Differentiate between a repository server and a powerhouse?
Explain Dataware house architecture .how data flow from intial to end?
What is an aggregator transformation?
How would you copy the content of one repository to another repository?
How do you set a varible in incremental aggregation