What is junk dimention?
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 |
write a query for how to eliminate the duplicate rows without using distinct?
What are the advantages of using informatica as an etl tool over teradata?
how we load the data from source to staging area
What is the difference b/w natural key and surrogate key
how to calculate the optimum cache size in aggregator transformation?
whats the option in informatica 7 version is outdated in informatica 8 version onwards.
how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy
How will u pas the data with out debugger?
performance wise which one is better in joiner and lookup transformation?why?explain clearly?
Did u used latest transformations of 8.6.0? for what?
What are the tasks that source qualifier performs?
what is the method of error handling when session is running?