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

After draging the ports of three sources(sql server,oracle,informix) to a single source qualifier, can you map these three ports directly to target?

6 13066

What are the Advantages of de normalized data?

3 9078

What is operational data source (ODS)?

7 27731

What is meta data and system catalog?

2 8425

What is factless fact schema?

1 9492

What is confirmed dimension?

3 10025

What is the capacity of power cube?

1 4495

What is the Difference between PowerPlay transformer and power play reports?

1 6294

What is IQD file?

1 7975

What is Cognos script editor?

Cognizant,

4297

What is difference macros and prompts?

2 6571

What is power play plug in?

2 6158

Which kind of index is preferred in DWH?

2 10652

What is hash partition?

2 8611

How can you define a transformation? What are different types of transformations in Informatica?

10 25964

Un-Answered Questions { Data Warehouse }

it will become easy if uuu provide website linkssss and list of consultanciessssss

2032

What is model?

1037

What is called Cognos powerplay?

1154

What is load manager?

1114

Explain the types of transformations?

1115

What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?

2209

Difference between flat files and relational sources?

2377

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

10539

What is the use of hoursfromtime() function in transformer stage in datastage?

1127

What is ibm datastage flow designer?

1210

can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2585

can we perform checkin and checkout through sandbox?

1233

What is a table alias in obiee 11g? Where and how will you create it?

1069

Differentiate between datastage and informatica?

1253

What is level prompt?

1007

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