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 |
Consider two cases: (1) Power Center Server and Client on the same machine (2) Power Center Sever and Client on the different machines what is the basic difference in these two setups and which is recommended?
what is plsql table?
without dynamic lookup how to insert new rows and update existing rows?
What is staging area?
can we use bulk loading when we use look in mapping
My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I want my Target as C_Id Week_Num Amt 100 45 2000 100 46 1500 101 45 2500 101 46 2000
What is the session task and command task?
can we use union transformation in joiner transformation?how?
1 Answers Dabur, Tech Mahindra,
What are limitations of joiner transformation?
What are the different tools in workflow manager?
What is Datadriven?
After a load is done to my target table, I need to insert a last row, which might be formed at some expression transformation and brought to target. Do I have to have separate mapping to be run after the 1st mapping? Or in a single mapping how to achieve this?