Interested to Buy Any Domain ? << Click Here >> for more details...
What is diff between Junk dimensions and conform dimension?
- 4 Answers
- 12688 Views
- Polaris, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / avinash
JUNK DIMENSION
A Dimension which cannot be used to describe the facts is
known as junk dimension(junk dimension provides additional
information to the main dimension)
ex:-customer add
Confirmed Dimension
A dimension table which can be shared by multiple fact tables
is known as Confirmed dimension
Ex:- Time dimension
| Is This Answer Correct ? | 9 Yes | 1 No |
Answer / nagireddy
a junk dimension is dimension but not using for
maping..like its a boolean value.but conform dimesion is
which dimension is shared by two or more than two fact
tables is called conform dimension.and conform dimesin
reduce the no of tables...
| Is This Answer Correct ? | 1 Yes | 0 No |
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 |
Answer / shar
junk dimensions are dimensions that contain miscellaneous data like flags,gender,text values etc that cannot be used for generating reports
Conformed dimension: if a dimension table is shared by multiple fact tables then that table is called as conformed dimension table.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is use Array size in datastage
Where do the datastage jobs get stored?
1.How to read multiple file from sequential stage. 2.If a file doesn't arrive or doesn't exists in sequential stage how do u handle this. 3.What do you do before taking data from source to staging area. 4. I have a remove duplicate stage and transformer stage.what will u do for optimizeing the performance of the job.
Distinguish between informatica & datastage. Which one would you choose and why?
What is the difference between odbc and drs stage?
What all the types of jobs you developed?
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.
What are operators in datastage?
is it possible to access the same job by two users at a time in DataStage?
How do you start developing a datastage project?
How many Key we can define in remove duplicate stage?
Explain the importance of surrogate key in data warehousing?
Teradata 
