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

How we will Developing new reports Using Data step programming and Macros ?

4 6450

why do u use shortcuts in informatica.?

iFlex,

4 29073

how do u move the code from development to production?

6 12761

what is confirmed dimension?

6 13811

Kimball and Inmon methodologies?

2 17010

star and snowflake schema?

6 13544

surrogate keys usage in Oracle and Informatica?

ITC Infotech, Oracle,

5 15787

scd methodology?

2 6194

version controlling in informatica?

3 17962

what r the values tht r passed between informatics server and stored procedure?

1 5408

what is parallel querying and what r hints.

1 5416

what happens when a batch fails?

3 8439

connected and unconnected lookups?

4 8645

what is scd?

6 17785

what are surrogate keys?

5 11549

Un-Answered Questions { Data Warehouse }

Describe the function and untility of the most difficult SAS macro that you have written.

2132

what cause the "error: connect:" and "error in the libname statement" when there weren't any such problems?

2201

Explain why are oltp database designs not generally a good idea for a data warehouse?

1041

What are the etl testing operations includes?

1123

Mention sas system options to debug sas macros.

1193

what are the Methods For Creating Reusable Transformations?

1189

What is etl tool in hadoop?

907

Informatica settings are available in which file?

1002

How can you validate all mappings in the repository simultaneously?

1383

what is null hypothesis? why do you consider that?

2922

Name a few sectors which use data warehousing?

935

What is the difference between the local container and shared container?

1116

What are the measure objects?

1217

Can we collect statistics on table level?

1051

WHAT IS METRIC STUDIO?WHAT IS SCORE CARDS HOW TO IMPLEMENT IT AND WHAT IS THE USE OF SCORE CARD?

6926

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