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 surrogate key?

9 27050

What is difference between Mapplet and reusable transformation?

Wipro,

9 44641

What is aggregate awareness?

1 9568

Explain reference cursor?

1 9700

What are parallel querys and query hints?

1 8157

While importing the relational source defintion from database,what are the meta data of source U import?

1 6377

Howmany ways yoU can update a relational source defintion and what are they?

1 5892

Where should yoU place the flat file to import the flat file defintion to the designer?

4 11234

To provide support for Mainframes source data,which files r used as a COBOL files

1 4416

Which transformation should u need while using the cobol sources as source defintions?

2 5620

How can yoU create or import flat file definition in to the warehouse designer?

2 8704

what is a transforamation?

5 8346

What are the designer tools for creating tranformations?

Informatica,

1 6237

What are the active and passive transforamtions?

2 7758

What are the connected or unconnected transforamations?

2 7246

Un-Answered Questions { Data Warehouse }

what is the synchonus? wht is the diff between synchronous and asynchronous what is the diff between v1 and v2 v3 delta modes in sap ecc

2547

what is sas application server, database server, sas olap server and sas metadata server? : Sas-di

1062

Highlight the main features of datastage?

1225

What is dimensional table?

1135

Why denormalization is promoted in universe designing?

1032

Can you state some of the innovations throughout history?

1048

How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

2030

What is SAS informats?

1169

How create measures and dimensions?

1138

what is degenerate key in oracle ?whare do we use it?

2618

What is the difference between teradata and basic rdbms?

1074

can we insert all types of charts in a list report? what r the realtime prompts?

2266

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

1143

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

1128

How many types of hash files are there?

1240

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