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 the difference between filter and conditin?

974

Explain how to export mappings to the production environment?

990

Explain can report net connect multiple datasource at a time in report creation time?

943

Explain the versions of reportnet?

1001

Explain what are the advantages of query studio compared to report studio?

1034

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

1011

Explain what is the difference between powerplay transformer and power play reports?

1175

Explain what are the mapping paramaters and maping variables?

1084

Explain the differences between normalizer and normalizer transformation?

1038

Explain what are the various file formats involved in reportnet?

956

Explain multivalued dependency?

998

Explain functional dependency?

1097

Explain what are the tasks that loadmanger process will do?

937

Explain what are the basic needs to join two sources in a source qualifier?

1154

Explain how does tuple-oriented relational calculus differ from domain-oriented relational calculus?

1236

Un-Answered Questions { Data Warehouse }

Explain what are components of report studio?

1115

Differentiate between a repository server and a powerhouse?

1132

What are the main features of datastage?

1296

State the working process of decimal_strip function?

2170

Explain factless facts?

992

Explain the code page compatibility?

1077

Which is the database redshift is using?

what is the difference between unique key and primary key? : Sas-di

1148

What are the differences between oltp and olap?

980

Explain the use lookup tables and Aggregate tables?

987

What is called a slice?

1039

What are all the types of report?

1106

What are three tier systems in etl?

1084

What are tpump utility limitations?

1135

Is it possible to define a single node as a Gateway node as well as worker node?

1132

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