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

Which are the olap tools available that are supported by oracle?

943

What is the difference between olap and datawarehosue?

968

Explain what are the different types of join operations?

985

Explain the different types of data warehousing?

1005

Explain what are non-additive facts in detail?

1045

What is is a star schema?

1185

Explain what is a view as it relates to system modeling?

1002

Explain what are slowly changing dimensions?

1034

I know of using applysimple, but there are other ways too?

968

Explain what are the various methods of getting incremental records or delta records from the source systems?

980

Why denormalization is promoted in universe designing?

997

Explain what are the various transformation available?

1034

How to reduce warnings?

945

What is the difference between a primary and secondary actor in use case modeling?

1076

Explain what is partitioning? What are the types of partitioning?

979

Un-Answered Questions { Data Warehouse }

What is a joiner transformation?

1005

What is the difference between Datastage 7.5 and 7.0?

1112

What does role playing dimension mean?

1056

4 yrs etl devloper roles and responsibilities?any body give solutions

2182

I know of using applysimple, but there are other ways too?

968

How to perform incremental load in datastage?

1220

Explain the difference between dw and bi?

1059

To import the flat file definition into the designer where should the flat file be placed?

1071

How are indexes created after completing the load process?

1660

what is the difference between native sql and cognos sql?

1015

What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

2399

What are all the problems you faced while validating tables and reports?

3488

What is difference between custom hierarchy and report based hierarchy?

1030

what is the end to end process meaning in my project(my project is development)and functionality plz tell me

2021

How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

2456

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