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 are cubes and olap cubes?

1049

What are the three tiers in etl?

1172

What are dimensions?

1131

What are the steps involved in etl process?

1104

What is initial load and what is full load?

1057

Explain different types of partitioning?

1097

List few etl bugs?

998

What are three tier systems in etl?

1126

What are your responsibilities as an etl tester?

1256

What is grain of fact?

1029

What are the types of data warehouse applications and what is the difference between data mining and data warehousing?

1059

What do you understand by the term ‘transformation’?

1100

Explain the key challenges that you face while performing etl testing.

1059

Mention few test cases and explain them?

985

Explain etl mapping sheets?

1130

Un-Answered Questions { Data Warehouse }

What is a logical size of a table and what does it depend on?

1021

What does “tail –f” command do and what is its use as an Informatica admin.

1147

Diff b/w Crossproduct and Outerjoin?

2337

How will you use the WHO Drug Dictionary for Reporting Clinical Trials?

2396

Explain the different types of data warehousing?

1037

How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

2030

What are the differences between datastage and informatica?

1229

9. What was the most complex type of report you dealt with?

2286

what is Forward,Reverse and Re_engineering?

2280

Explain fact constellation schema?

1089

What is parallel processing in informatica?

1798

Explain snowflake schema?

1094

When do we analyze the tables?

1022

What are “business rules” in ab initio business rules environment (bre)?

2094

What do mean by local and global repository?

1283

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