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 are parallel querys and query hints?

2191

DWH architecture?

6 18502

What are cursors?

4 9048

Advantages of de normalized data?

2 11339

What is operational data source (ODS)?

2 10470

What is meta data and system catalog?

2261

What is factless fact schema?

2 6705

What is confirmed dimension?

JPMorgan Chase,

7 16244

What is the capacity of power cube?

2 6607

Difference between PowerPlay transformer and power play reports?

CTS,

2496

What is IQD file?

1 5542

What is Cognos script editor?

2504

What is difference macros and prompts?

2245

What is power play plug in?

3 4670

Which kind of index is preferred in DWH?

1 8588

Un-Answered Questions { Data Warehouse }

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6079

What is your spectra photometer working principles?

945

How do you take back up of repository?

1108

What are routines in datastage? Enlist various types of routines.

1062

Give some difference between oltp and olap.

975

I have two queries in first query i have to show all values,in second query i have to show 3 values and want to hide 3 values what prompt ur going to use, why that prompt

2239

How to join three sources using joiner?

1054

Explain is data mart?

982

Can you define dimension?

1047

what is pmrep command?

11508

How does the aggregator transformation handle null values?

1109

What is degenerate dimension table?

966

What is clusterservices in obiee ? Why its used?

871

What is the difference between er modeling and dimensional modeling?

1092

what is Active lock explain

2749

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