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 is hash partition?

TCS,

3 5173

What is DTM session?

1 9151

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

TCS,

7 10826

What is mapplet?

1 6431

What is query panel?

1 3845

What is a look up function? What is default transformation for the look up function?

1 5062

What is difference between a connected look up and unconnected look up?

1 6642

What is staging area?

9 17033

What is data merging, data cleansing and sampling?

1 7613

What is up date strategy and what are th options for update strategy?

2 5082

OLAP architecture?

CTS, Honeywell,

1 5948

What is subject area?

2 10462

Why do we use DSS database for OLAP tools?

3 10490

What is ?Data Warehousing??

Accenture,

3 6464

What are Data Marts?

2 5721

Un-Answered Questions { Data Warehouse }

How will you create interactive dashboards ?

854

file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

888

what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?

2569

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

919

At which levels you can set the vldb properties? Which level has the highest pecedence?

898

tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you

771

What do you mean by Drill down and Drill Up?

936

How to Reset Pagenumbers in one report.

2598

What are the different types of olap? Give an example?

976

How to reverse the string using SQL?

1427

Explain about Informatica server process that how it works relates to mapping variables?

1010

Which transformation should we use to normalise the COBOL and relational sources?

1143

What are different table types used in teradata?

981

How to sort the dynamic objects alphabetically on the Universe based on and SQL Server

2233

-------------How you design DWH?

2254

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