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 is a linked cube?

1006

What is a full backup?

961

Do you view contain data?

935

How can we run the graph? What is the procedure for that? How can we schedule the graph in unix?

953

What is hybrid slowly changing dimension?

1036

Explain about core dimension,

985

What is data warehouse architecture?

1048

What is degenerate dimension table?

1001

What is dimensional modelling?

985

What are data validation strategies for data mart validation after loading process?

1016

What is surrogate key? Where we use it? Explain with examples.

1027

What is type 2 version dimension?

974

What is the advantages data mining over traditional approaches?

967

What is surrogate key? Where we use it?

997

For faster process, what we will do with the universe?

992

Un-Answered Questions { Data Warehouse }

What is the 4 + 1 view model as it relates to system modeling?

1040

How you prepared reports for OLAP?

1597

Give some difference between oltp and olap.

1008

Describe the between keyword in teradata?

1040

Can a dimension table contain numeric values?

1058

On which transformations you created partitions in your project?

1348

I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

1068

What is a fact, dimension, measure?

1208

what do the sas log messages "numeric values have been converted to character" mean? What are the implications? : Sas programming

1275

How to performance tune reports?

1164

What are normalization, first normal form, second normal form and third normal form?

1052

What does cheating measurement mean?

1062

What are the reasons to use a chameleon method in data warehousing?

1057

what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

2305

How do you take back up of repository?

1162

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