what is a junk dimension ?
- 14 Answers
- 60111 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
How do you handle two sessions in Informatica
What is the difference between a connected look up and unconnected lookup?
define galaxy repository in informatica
server hot-ws270 is connect to Repository B. What does it mean?
What are multi-group transformations?
Enlist few areas or real-time situations where informatica is required.
What is the difference between informatics 7x and 8x and what is latest version?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What is meant by target load plan?
Explain the difference between mapping parameter and mapping variable?
what are factless facts? And in which scenario will you use such kinds of fact tables.
How do you set a varible in incremental aggregation
What are the basic requirements to join two sources in a source qualifier transformation using default join?
How many ways are there to do 'remove duplicate records in informatica'?
