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

What is cognos reporting tool?

1089

Can you define a query subject?

1018

Can you define cognos impromptu?

1029

Can you explain cognos planning?

1092

Can you define cognos powerplay?

1094

Can you explain a cognos controller?

1021

What is the difference between orabulk and bcp stages?

1025

What is the difference between validated and compiled in the datastage?

1293

What is the differentiate between data file and descriptor file?

1362

What is the difference between odbc and drs stage?

1092

Can you explain repository tables in datastage?

1408

What is the roundrobin collector?

1099

What is difference between join, merge and lookup stage?

1097

What is quality stage?

987

Can you explain engine tier in information server?

1135

Un-Answered Questions { Data Warehouse }

If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?

2046

Describe the main features of datastage?

1076

What is meant by incremental load?

1096

How can a transformation be made reusable?

1168

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1125

Can we override a native sql query within informatica?

1036

To save time, can many reports be run at the same time?

1029

What is static prompt in microstrategy?

973

What are the advantages of query studio compared to report studio?

893

TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1866

what is mean by complex business rule ?

2162

what do you mean by kimball?

1002

What is the use of Cognos scenario?

1194

What is enterprise data warehousing?

1047

How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.

1035

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