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
Why do you need stage variables?
What are the features of datastage flow designer?
How many types of hash files are there?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
How one source columns or rows to be loaded in to two different tables?
What is data partitioning?
Explain ibm infosphere information server and highlight its main features?
How to reverse the string using unix?
how to implement scd2 in datastage 7.5 with lookup stage
What is a folder? Difference types of stages?
How can you write parallel routines in datastage PX?
Define APT_CONFIG in Datastage?
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.
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
whom do you report?