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

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...

Answer / 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.

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.

Thanks to all people who are posting their comments...

1 Answers   CTS,

---

Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

0 Answers   ABC, TCS,

---

Main Function of the Staging area in DWH ?

2 Answers  

---

what is the function in Transformer stage can act as Rank function in Oracle

1 Answers   Reliance,

---

Hi Can any one help regarding below INPUT NAME LOC Ram hyd Ram ban Raj chn Raj Pun Sam del OUPUT NAME LOC Ram Hyd ban Raj chn pun sam del

3 Answers   HCL,

---

What are the different database update actions available?

1 Answers   HP,

---

how to delete one row in target dataset

0 Answers   Satyam,

---

What are system variables and sequencers in datastage

0 Answers  

---

is it possible to access the same job by two users at a time in DataStage?

2 Answers   IBM,

---

What is RCP?

2 Answers   TCS,

---

I WANT TO SEND SYSDATE AS PARAMETER,SO WHAT COMMAND I SHOULD USE TO CALL SYSDATE?

4 Answers   ME,

---

which is the most complex job in your career? Please tell me answer?

2 Answers   IBM, Wipro,

---