Interested to Buy Any Domain ? << Click Here >> for more details...
What is diff between Junk dimensions and conform dimension?
- 4 Answers
- 12534 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 |
How to remove blank spaces from data?
job locking methods? How can we unlock the job?
in oracle target stage when we use load option and when we use upsert option?
Define meta stage?
How to transfer file from one system to another system in UNIX?which command to be use?
how can we send even and odd records from a sequential file to two different targets
10 Answers IBM, iGate, TCS,
Where the datastage stored his repository?
What are the different layers in the information server architecture?
where we use column generator stage in real time scenario?
why dataset ?
how to do pergformence tuning in datastage?
How many types of stage?
Teradata 
