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

How to use consolidations in microstrategy report?

1057

how can you direct the sql generated to use a specifc table?

983

What is static prompt in microstrategy?

988

What are the various file formats involved in reportnet?

999

Explain how many ways you create ports?

1032

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

987

Why should you put your data warehouse on a different system than your oltp system?

988

Explain what are components of reportnet?

988

Explain a relation schema and a relation?

1124

Explain what is the difference between stop and abort?

1055

What are components of report studio?

1067

What are the mapping paramaters and maping variables?

1044

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

899

Explain what is the extension of file to save template?

985

What is the limit to the number of sources and targets you can have in a mapping?

1116

Un-Answered Questions { Data Warehouse }

update strategy transformation in informatica

1076

What is the purpose of Dataware Control?

1065

On which transformations you created partitions in your project?

1359

options available in sequence job to run,validate?

1331

Explain how you can debug and test your SAS program?

1026

Explain what is batch and describe about types of batches?

1091

What is the difference between datastage and datastage tx?

1077

Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?

3638

What is the difference between regular dimension and derminant?

2286

Explain what is data validation strategies for data mart validation after loading process?

1041

What are all the types of indexes in Cognos?

1247

What are the advantages of informatica?

1023

What would be the result of the following SAS function (given that 31 Dec, 2000 is Sunday)?

1169

How is cognos model organization works?

1105

Explain three-tier connection?

970

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