Interested to Buy Any Domain ? << Click Here >> for more details...
what is a junk dimension ?
- 14 Answers
- 62746 Views
- Atos Origin, Cognizant, HS, NIIT, TCS, I also Faced
- E-Mail Answers
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
Can we create a Integration service without a Repository service and vice versa?
4 yrs etl devloper roles and responsibilities?any body give solutions
What do you mean by channel change?
Name the different lookup cache(s)?
What is target designer and target load order?
where to store informatica rejected data?
What is pmcmd command?
How many number of sessions can one group in batches?
What is InformaticaPowerCenter?
What do you mean by worklet?
How can you increase the performance in joiner transformation?
How will the document be delivered to me?
Differentiate between a database and data warehouse?
Why update strategy and union transformations are active? Explain with examples.
What are pre and post-session shell commands?
