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 26742

What is difference between Mapplet and reusable transformation?

Wipro,

9 44357

What is aggregate awareness?

1 9498

Explain reference cursor?

1 9574

What are parallel querys and query hints?

1 8100

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

1 6279

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

1 5798

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

4 11083

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

1 4338

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

2 5521

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

2 8586

what is a transforamation?

5 8146

What are the designer tools for creating tranformations?

Informatica,

1 6158

What are the active and passive transforamtions?

2 7585

What are the connected or unconnected transforamations?

2 7141

Un-Answered Questions { Data Warehouse }

I need level 2 to 5 sas using companies in india

2383

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

2069

Can you explain a cognos controller?

1026

What are the guidelines to be followed while using union transformation?

1146

Where the data cube technology is used?

962

IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

1041

Name the different sorting methods in datastage.

1054

Explain about alerts in bos, under what situation we need to use alerts?

1056

What is the difference between 'using group by in the sql of the report' and 'having a group section in the report'?

943

How to elaborate powercenter integration service?

1137

How abinitio eme is segregated?

1284

What is factless fact tables?

1212

What are the etl testing operations includes?

1112

What do you understand by the term 'model durability'?

1016

What is a deadlock and how it occurs?

1164

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