Answer / sri ram

Conformed dimension is a dimension which is connected to or
shared by more than one fact table.

Eg:A business which takes care of both sales and orders of
products then product dimension becomes a conformed
dimension for both sales fact and order fact

Answer / rr

A dimension that will remains unchanged in entire
datawarehouse. It can be used across all the fact tables.

Answer / suresh godugu

A dimension that carries the same meaning across the
different fact tables in called conformed dimension

Answer / mohini

the dimention table is connect to fact table.the splitted dimention tables are also connect the fact tables.the spiltted dimention tables also carries the same meaning across the total transaction.the dimention tables contains denormalized data.ths z called confirmed dimension.

Answer / jayachandra

A dimenssion which is shared by multiple fact tables is
known as "Confirmed dimenssion".
ex:customer dimenssion

Answer / lokii

A dimension which connects a fact table and a factless fact
table.

How to retrieve last two days updated records?

4 Answers  

have you developed documents in your project? and what documents we develop in realtime?

2 Answers   IBM,

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

2 Answers  

How to load a relational source into file taget?

2 Answers  

When do you use mapping parameters? (In which transformations)

1 Answers  

I have been working in Informix-4gl for the past 2 years in an MNC company.But I'm interested to work in Business Intelligence tools. Is it possible to change the technology now? I'm really confused, please help me

1 Answers  

if we are extracting 600000 records from a source table so how much volume of records frequently we load in warehouse. (Iknow its depend on client requirement) still i want to know how much volume of records store in warehouse.

2 Answers   IBM,

I have table with ID,PRD_DT,PRD_FLAG,CUST_DT,CUST_FLAG I need to get max date and its corresponding flag for both the date columns. Ex:- 1A,10/3/2015,AC,10/3/2015,XY 1A,10/4/2015,AB,10/2/2015,XZ Output needed 1A,10/4/2015,10/3/2015,XY I have 100 million + in the table so avoid self-join...

2 Answers   Amex,

There are 4 flat files with number of records as indicated below. Which files should be picked first for joining using joiners so as to get best performance. File A - 1000 records File B - 100 records File c - 10000 records File D - 10 records Please explain. Thanks and Regards,

1 Answers   Amdocs,

How to fix the etl bugs..Tell me the process?

1 Answers   IBM,

Which version configuration tool used in ur project?

0 Answers   CTS, TCS,

What is expression transformation?

0 Answers