Data Warehouse Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Teradata (490)
Business Objects (875)
Cognos (1143)
Informatica (2428)

SAS (1049)
Micro Strategy (282)
ETL (315)
OBIEE (92)

Data Warehouse Interview Questions

Questions Answers Views Company eMail

why we use datawarehouse

HCL,

1977

why we need informatica

HCL,

2 13507

what is degenerated dimension table with scenario

HCL,

2 3678

Explain factlessfact table with scenario

HCL,

1 3373

What is confirmed dimension with scenario

HCL,

1 3430

Diffrence between static and dynamic cache

HCL,

2 6458

If u r using dynamic cache lookup port will be thier in thet which option u will select

HCL,

1 3435

What is souce qualifier transformation it is active or passive

HCL,

2 10440

What is an aggregator transformation? it is active why cant it be passive explain?

HCL,

3 18090

Diffrence between 7.1,8.1 and 8.6

HCL, Wipro,

3 11889

How the dimensions will be loaded?

HCL,

2122

How the facts will be loaded? explain

HCL,

2 8194

What is the stored procedure ? What is the need of stored procedure ? How to create a stored procedure Universe?

HCL,

1 5910

What is partioning?how many types of partinings are there

HCL,

2 7566

Suppose i have the sinario like this column1: e1,e2,e3,e4 : column2: 1,0,1,0 : column3: M,F,M,F : in this i want to disply 1 is male and 0 is female which is added to the another column like column 4 what is the process?

HCL,

2 5570

Un-Answered Questions { Data Warehouse }

What is the use of cognos decision stream?

1093

in u r data u having duplicates how to fetch the latest data in our report?

5743

What are the various methods of getting incremental records or delta records from the source systems?

931

Connecting to iserver volume using idapi classes(java classes) and after connecting to iserver I want to execute the rox on iserver and also want know the status whether that job is succesfully run or not?

1044

Explain the data types present in bo and what happens if we implement view in the designer and report?

1032

Explain where to store informatica rejected data? How to extract the informatica rejected data?

1013

Can you define bitmap index?

1063

Pdl with an example?

1110

how many steps are there in etl process?

981

How to generate sequence numbers?

1089

Explain how to get the first 100 rows from the flat file into the target?

975

How to limit the cut,copy and paste operations for an user in reportlevel? Can anyone please send me the steps as i am new to cognos?

2579

What is active and passive stage?

1414

What is a sorter transformation?

1102

How would you configure wh authentication?

952

For More Un-Answered { Data Warehouse } Questions Click Here