What is junk dimention?
- 3 Answers
- 6956 Views
- Patni, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / krishna
A dimention table which is type of boolean or flag. its not
used in the business analysis
| Is This Answer Correct ? | 10 Yes | 0 No |
A Dimension which not participated in the key performance
indicator.
Eg : phone number, address.
If it is wrong means please mail me chandranmca2007@gmail.com
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / chinmay
Junk dimesnion is aimension table consisting attributes
that do no belong to any fact table or any form of existing
dimesnion .
Usually it is used to hold indicator yes/no , true/false.
| Is This Answer Correct ? | 0 Yes | 0 No |
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
write a query to retrieve the latest records from the table sorted by version(scd)
have u done any performance tuning? how u ll do?
What is the difference Between Mapping parameter and variable
In Flat file Input is A B C I need output like this A A A B B B C C C. How will u achieve this?
how to get the data from the client machine and how to get server location data to client loction can any body explain to me
Briefly define reusable transformation?
suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping?how
how to convert 101 raja 101 raja sekar reddy 101 sekar----------> 101 reddy
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
what are the settiings that u use to cofigure the joiner transformation?
What is Session and Batches?
Teradata 
