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 is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
What are transforms and what is the differenece between routines and transforms?
How do you run datastage job from the command line?
Difference between sequential file and data set?
What are routines in datastage?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
Differentiate between operational datastage (ods) and data warehouse?
What is difference between symmetric multiprocessing and massive parallel processing?
What are the components of ascential data stage?
What is active and passive stage?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
What is a folder? Difference types of stages?
how to abort the job its matain duplicates?
What is aggtorec restructure operator?