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 are data mart and dwh normalized or denormalized? Do both of them exist in

1049

What is the extension of file to save template?

1019

Explain normalization?

1143

How to get the first 100 rows from the flat file into the target?

1224

Explain why dimenstion tables are denormalized in nature?

934

Explain what are components of report studio?

1116

Explain what is metadata reporter?

988

What are the advantages and disadvantages of reporting directly against the database?

997

Explain what is difference between query studio and report studio?

998

Explain ddl (data definition language)?

1021

Explain how to generate iqd file from framework manager?

957

How to limit the max no of rows retrieved in the report?

999

Code the tables statement for a single-level (most common) frequency?

945

What is perform recovery?

1126

Can we start and stop single session in concurent bstch?

958

Un-Answered Questions { Data Warehouse }

What is meant by drill down?

993

What are the components used in smp and massively parallel processing (mpp) machines?

1072

what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?

1045

Can Bo generates the Report from the cubical data Explain?

2048

How is security handled?

1011

Can you connect multiload from ab initio?

1235

What is pass through metrics in microstrategy?

999

explain the methodology of Data Warehousing?(Polaries)

2313

What is the difference between teradata and oracle?

1039

Define data warehouse?

1050

Who needs data warehousing?

1078

Enlist various types of routines in datastage.

1268

How conflicts occur and what are the ways to resolve them?

973

What information does a .dbc file extension provides to connect to the database?

1250

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5807

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