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?

2228

DWH architecture?

6 18701

What are cursors?

4 9217

Advantages of de normalized data?

2 11442

What is operational data source (ODS)?

2 10585

What is meta data and system catalog?

2300

What is factless fact schema?

2 6800

What is confirmed dimension?

JPMorgan Chase,

7 16464

What is the capacity of power cube?

2 6696

Difference between PowerPlay transformer and power play reports?

CTS,

2517

What is IQD file?

1 5615

What is Cognos script editor?

2554

What is difference macros and prompts?

2307

What is power play plug in?

3 4776

Which kind of index is preferred in DWH?

1 8654

Un-Answered Questions { Data Warehouse }

How do you register plug-ins?

962

how to load rows into fact table in data warehouse

1188

IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY

10396

Enlist the functions performed by sas.

1127

Write the prerequisite tasks to achieve the session partition?

1157

what is size of u r database?

2305

why we use dmr model in cognos report studio ? give me difference between dmr model and relational model.

1954

Name the types of gateway?

1010

What is the function of Stop statement in a SAS Program?

1151

How will you enable or disable caching in the system level and table level?

894

What do you mean by query studio?

945

Explain the different types of views used in cognos.

949

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

2136

my source is junk data how will u remove that junk data by using unix please any one replay me

3704

What are the uses of etl tools?

1128

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