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?

1008

Explain what are the different methods of loading dimension tables?

965

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?

972

Explain what is full load & incremental or refresh load?

998

Explain what is the metadata extension?

1048

What are the main steps to build the data warehouse?

1128

Explain what is the difference between datawarehouse and bi?

984

What is scd1 , scd2 , scd3?

1098

Explain the difference between oltp and olap?

1133

What is a data warehousing?

1171

What is a fact table?

1 1650

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

985

Explain where do we use semi and non additive facts?

1031

What is cost benefit analysis (cba)?

1004

Explain what is the data type of the surrogate key?

987

Un-Answered Questions { Data Warehouse }

AWS Redshift is basically works on nodes and cluster and which of following option Redshift is based on?

How to delete duplicate row using informatica?

1058

Name the types of report?

969

What are fact, dimension, and measure?

1350

How to do unit testing in informatica? How to load data in informatica ?

1142

Given an unsorted data set, how to read the last observation to a new data set?

1369

how would you create multiple observations from a single observation? : Sas programming

1011

Why managing the data is important?

1025

Define datastores in cognos?

964

how do u extract data from different data sources explain with an example?

2263

Explain which are the olap tools available that are supported by oracle?

1021

What is a dimensional model?

996

How can we handle two sessions in informatica?

1046

How might you approve all mappings in the archive all the while?

1026

Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?

1281

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