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
What are the difference types of stages?
in oracle target stage when we use load option and when we use upsert option?
Difference between sequential file and data set?
Describe the main features of datastage?
What is a quality stage in datastage tool?
What are iconv and oconv?
What is data partitioning?
Define APT_CONFIG in Datastage?
Explain entity, attribute and relationship in datastage?
How can we improve the performance in datastage?
How a routine is called in datastage job?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
What is the project in datastage?
what are the errors,warnings in datastage
What is the sortmerge collector?