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
State the difference between an operational datastage and a data warehouse?
What are datastage sequences?
How to RD using transformer?
Highlight the main features of datastage?
in oracle target stage when we use load option and when we use upsert option?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
How many types of stage?
Differentiate between datastage and informatica?
How we can covert server job to a parallel job?
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.
Describe link sort?
whom do you report?
how can we create rank using datastage?what is the meaning of rank?
which r the connectors used in san?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC