What is diff between Junk dimensions and conform dimension?
- 4 Answers
- 12816 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 |
I have Seq file, I don't want 10, 11th(or any two records like 20, 30th records ) records in the output
What is the surrogate key? what is the use of surrogate key? how to Create surrogate key Generator in scd2 in 8.5?
What are stage variables, derivations and constants?
how to implement scd2 in datastage 7.5 with lookup stage
1)Source file contains one record, I want 100 records in target file.
What is size of a transaction and an array means in a datastage?
What are the types of hashed files in data stage
Can you define merge?
Explain datastage architecture?
how to validate the jobs
1.How do u handle NULL in sequential stage. 2.Difference between switch stage and filter stage.
What is the difference between operational data stage (ods) and data warehouse?
Teradata 
