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
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
How many Key we can define in remove duplicate stage?
What is the difference between in process and inter process?
Define APT_CONFIG in Datastage?
Can we use target hash file as a lookup ?
Is the value of staging variable stored temporarily or permanently?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
What is the difference between orabulk and bcp stages?
What are the processing stages?
what is repositery?
project Steps,hits, Project level HArd things,Solved methods?
What is the difference between odbc and drs stage?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
what is the difference between == and eq in UNIX shell scripting?
What is a quality stage in datastage tool?