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


Please Help Members By Posting Answers For Below Questions

What are the steps needed to create a simple basic datastage job?

667


How one source columns or rows to be loaded in to two different tables?

668


What are some different alternative commands associated with "dsjob"?

666


What a datastage macro?

641


I have a few records just I want to store data in to targets cycling way how?

1907






What is size of a transaction and an array means in a datastage?

744


Can you explain players in datastage?

713


What is the command line function to import and export the ds jobs?

686


What are iconv and oconv?

779


What is the use of hoursfromtime() function in transformer stage in datastage?

591


What are the main differences you have observed between 7.x and 8.x version of datastage?

626


What is the purpose of interprocessor stage in server jobs?

1731


How many types of stage?

684


Explain the importance of surrogate key in data warehousing?

719


how to sort two columns in single job in datastage.

2549