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?

2231

DWH architecture?

6 18707

What are cursors?

4 9225

Advantages of de normalized data?

2 11444

What is operational data source (ODS)?

2 10590

What is meta data and system catalog?

2303

What is factless fact schema?

2 6802

What is confirmed dimension?

JPMorgan Chase,

7 16466

What is the capacity of power cube?

2 6702

Difference between PowerPlay transformer and power play reports?

CTS,

2517

What is IQD file?

1 5617

What is Cognos script editor?

2559

What is difference macros and prompts?

2307

What is power play plug in?

3 4785

Which kind of index is preferred in DWH?

1 8656

Un-Answered Questions { Data Warehouse }

What is full load & incremental or refresh load?

1203

in u r data u having duplicates how to fetch the latest data in our report?

5742

What data formats does Redshift Spectrum support?

Whats difference betweeen operational data stage (ods) and data warehouse?

1116

Clarify the utilization of aggregator cache record?

1002

Differentiate between joiner and lookup transformation?

1102

What is native users?

1167

Explain what is redshift?

Different phases of multiload?

1013

Do we follow ADAM in analysis dataset development?How? Usually which version? Why is it necessary?

2413

Define Pmrep command?

1065

Why do we use exception activity in Datastage?

1314

What are the other names given to data warehousing?

1098

What is the use of function Proc summary?

1285

Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

1105

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