What is diff between Junk dimensions and conform dimension?
Answer Posted / vinod upputuri
Junk dimension: This dimension is mainly used for reference
purpose. It contains textual codes and flag variables.
Ex: country_id,Country_name
IND INDIA
Conform dimension: AS Avinash said the dimension table which
is shared by multiple fact tables are called as Conform
Dimension table.
Date,Geography,time etc.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Name the different types of Lookups in Datastage?
What is aggtorec restructure operator?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
project Steps,hits, Project level HArd things,Solved methods?
Define Job control?
Have you have ever worked in unix environment and why it is useful in datastage?
What is a quality stage in datastage tool?
Describe routines in datastage? Enlist various types of routines.
Is it possible to query a hash file?
How do you run datastage job from the command line?
What are the partitioning techniques available in link partitioner?
How to implement complex jobs in data stage?
Can you implement SCD2 using join, transformer and funnel stage?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
What is datastage engine?