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

Explain when do we analyze the tables? How do we do it?

1 1069

Explain what are the different methods of loading dimension tables?

1 1020

Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?

1 1023

Explain what is full load & incremental or refresh load?

1 1064

Explain what is the metadata extension?

1 1121

What are the main steps to build the data warehouse?

1 1184

Explain what is the difference between datawarehouse and bi?

1 1031

What is scd1 , scd2 , scd3?

1 1159

Explain the difference between oltp and olap?

1 1192

What is a data warehousing?

1 1253

What is a fact table?

1 1767

What is normalization, first normal form, second normal form, third normal form?

1 1040

Explain where do we use semi and non additive facts?

1 1084

What is cost benefit analysis (cba)?

1 1065

Explain what is the data type of the surrogate key?

1 1052

Un-Answered Questions { Data Warehouse }

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8286

Write the unconnected lookup syntax?

1148

explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com

4192

Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks

2313

can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance

2306

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

1202

Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A

3442

how many reports have u created ? explain a few.

2160

How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

1197

hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com

1997

What is the difference between business requirement document and use case document.

1083

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?

1101

How do you remove duplicate records in informatica? And how many ways are there to do it?

1233

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1670

HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com

2104

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