Interested to Buy Any Domain ? << Click Here >> for more details...
what is a junk dimension ?
- 14 Answers
- 63355 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
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
Please let me know how to make Data masking in informatica..
How are indexes created after completing the load process?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
How many numbers of sessions can one group in batches?
What do you mean by blocking transformation?
How do you promote a non-reusable transformation to reusable transformation?
What is the commit type if you have a transaction control transformation in the mapping?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
Explain in detail scd type 2 through mapping.
What are the informatica performance improvement tips
Tell me about MD5 functions in informatica
How does a sorter cache works?
What is Data Caches size?
Mention a few design and development best practices for informatica?
