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

How to load time dimension?

Ford,

1 15865

In update strategy target table or flat file which gives more performance ? why?

7 26580

How do you create single lookup transformation using multiple tables?

TCS,

6 44887

Why touse stored procedure in ETL Application?

2 12033

How to improve the performance of Aggregate transformation?

Dmss,

3 14455

What is critical mapping?

2 11508

How to call stored Procedure from Workflow monitor in Informatica 7.1 version?

Accenture,

1 20005

How to view and Generate Metadata Reports?

1 7935

what is difference between COM & DCOM?

Satyam,

1 11289

what is the gap analysis?

1 9599

How to recover sessions in concurrent batches?

3 15903

what are the different types of transformation available in informatica and what are the mostly used ?

TCS,

3 25473

what is Partitioning ? where we can use Partition?

IBM, TCS,

2 23499

what is surrogatekey ? In ur project in which situation u has used ? explain with example ?

6 14511

Where is the cache stored in informatica?

Infosys, Satyam,

5 38414

Un-Answered Questions { Data Warehouse }

how much memory space occupied real time project (roughly)?

2289

What is meant by a Clique?

1118

Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

7507

How to know the time taken for particular report execution?

1014

describe how to adjust the performance of data integrator? : Sas-di

1071

How do you use reject loader.

2653

What is exclusive and normal mode for repository services?

1193

Explain the term 'primary key' related to relational database management system?

1091

How do you import and export the datastage jobs?

1215

Differentiate between data file and descriptor file?

1108

Is it possible to define a single node as a Gateway node as well as worker node?

1188

Whats difference betweeen operational data stage (ods) and data warehouse?

1172

What are the functions involved in shared information architecture?

1129

what are the components in the cognos connection page consists (eg: my folder, public folder,directions, schedule management tool etc.....)

2141

What is difference macros and prompts?

2395

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