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 |
How You Pull the records on daily basis into your ETL Server.
How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)
What is the difference b/w natural key and surrogate key
How can you differentiate between powercenter and power map?
In informatics server which files are created during the session rums?
In which circumstances that informatica server creates Reject files?
how to get max value record into one target and remaining records into another target?
What are the scheduling options to run a sesion?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
If session fails after loading 10000 records in the target,how can we load 10001 th record when we run the session in the nexttime?
What is difference between stored procedure transformation and external procedure transformation?
Design a mapping to load the cumulative sum of salaries of employees into target table?