What is diff between Junk dimensions and conform dimension?
- 4 Answers
- 11026 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 |
Explain the functionality of your current project?
1 Answers IBM, Miles Software,
explain unit testing,systemtesting,integrated testing
hi this is kiran i have one table i want divide the table with two different table like even rows and odd rows how can i do this one tell me plzz
Triggers,VIEW,Procedures
How do you remove duplicate values in datastage?
How can we run same job in 1 day 2 times
1.How do u handle NULL in sequential stage. 2.Difference between switch stage and filter stage.
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
How can we read latest records in a text file named file1.txt using seq file stage only? file1 having 100 records in that 5 record sare latest records.How can we read that latest records?
How many number of reject links merge stage can have?
1.What is a delta record? How you will read it? 2.What are the different types of sorting?
I have oracle enterpaise stage, oracle bulkloader stage, ODBC stage and I want to load data in to target, which of the above stages do I need to use and why?
Teradata 
