What is diff between Junk dimensions and conform dimension?
Answer Posted / avinash
JUNK DIMENSION
A Dimension which cannot be used to describe the facts is
known as junk dimension(junk dimension provides additional
information to the main dimension)
ex:-customer add
Confirmed Dimension
A dimension table which can be shared by multiple fact tables
is known as Confirmed dimension
Ex:- Time dimension
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
How rejected rows are managed in datastage?
What are routines in datastage?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
How to reverse the string using unix?
What is the difference between hashfile and sequential file?
What are system variables and sequencers in datastage
What are the job parameters?
How do you reject records in a transformer?
What is the purpose of pivot stage and types of containers in datastage
Differentiate between datastage and informatica?
Difference between server jobs & parallel jobs?
Describe the main features of datastage?
How you can fix the truncated data error in datastage?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
Distinguish between informatica & datastage. Which one would you choose and why?