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 usage analysis in datastage?

1163

What is size of a transaction and an array means in a datastage?

1314

How many types of views are there in a datastage director?

1283

Why we use surrogate key?

1235

Define oconv () and iconv () functions in datastage?

1416

Name the third party tools that can be used in datastage?

1075

Define ds designer?

1278

Differentiate between odbc and drs stage?

1050

How do you find the number of rows in a sequential file?

1 3759

Why do we use link partitioner and link collector in datastage?

1137

How can one find bugs in job sequence?

1411

Differentiate between operational datastage (ods) and data warehouse?

1178

Differentiate between datastage and datastage tx?

1051

Why does microstrategy object manager search for object dependencies?

971

What is level metrics in microstrategy?

1030

Un-Answered Questions { Data Warehouse }

What are the different clients of powercenter?

1060

If you want to use the same piece of code in different jobs, how will you achieve it?

1156

Different qualification between a related rotate toward the sky and isolates look upward?

986

Could you explain what is enterprise data warehouse?

1148

How can you generate reports in informatica?

1029

Explain what is the advantages data mining over traditional approaches?

1029

Highlight the limitations of TPUMP Utility.

1111

How to generate the Catalog in Cognos? Basically all post describing generating the Catalog from cognos impromptu . Is there any way to generate the Catalog using Cognos Administration or Framework Manager?

2054

Imagine this, you are required to reset the password for all users at a time. How would you do that?

951

how to generate the test data in sas without input data? : Sas-administrator

1137

Which columns go to the fact table and which columns go the dimension table?

961

Is union transormation is active transformation?

975

What are the types of schemas we have in data warehouse and what are the difference between them?

941

What are components of reportnet?

1075

how many reports do u create in ur project?i don't have real time exp..tell me based on ur exp..for interview pt of view,don't say it depends on ur project and u? thanks in advance..

2110

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