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.

How do you remove duplicate values in datastage?

0 Answers  

---

if ename='subbu' while running job the job should be abort how come?

3 Answers   IBM,

---

if the source file is CID,CCODE,CONNDATE,CREATEDBY 0000000224,1000,20060601,CURA 0000000224,2000,20050517,AFGA 0000000224,3000,20080601,TUNE 0000000225,1000,20020601,CURA 0000000225,2000,20050617,AFGA 0000000225,3000,20080601,TONE AND TARGET is oracle following are the validations cid loaded with unique records leading zeors has to be deleted while loading cid in target load only customer who got early connected to company conn_date should be loaded into oracle date format cid datatype is varchar2 in target conn_date is data datatype ccode is varchar2 0000000224,1000,20060601,CURA 0000000224,1000,20060601,CURA

2 Answers  

---

plz tell me some dimentional and fact table names in banking project?

2 Answers   Virtusa,

---

How to perform incremental load in datastage?

0 Answers  

---

DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks

0 Answers  

---

source contains 2 columns comes to target 4 columns how

1 Answers   IBM,

---

while we using change capture stage we have to be take two table thats are 1.before table 2. after table . what is before table and after table please give me clear notation Thank You very much in advance

2 Answers   MGL,

---

i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

0 Answers  

---

I have a few records just I want to store each records tow times in target how?

2 Answers   Polaris,

---

What are the environmental settings for data stage,while working on parellel jobs?

2 Answers   Satyam,

---

Sequential file i have one record,i want 100 records in target?How can we do that?Pls explain me and what stages are there?What logic?

1 Answers   TCS,

---