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
What is the different type of jobs in datastage?
root tree will find which is server job and which is parallel job?
Name the different sorting methods in datastage.
What is a datastage job?
Can you explain link buffering?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
If you want to use a same piece of code in different jobs, how will you achieve this?
Differentiate between datastage and informatica?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
what is the use of surogate key in datastage
What is the flow of loading data into fact & dimensional tables?
What are the job parameters?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
What all the types of jobs you developed?
how can we create rank using datastage?what is the meaning of rank?