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 15759

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

7 26283

How do you create single lookup transformation using multiple tables?

TCS,

6 44615

Why touse stored procedure in ETL Application?

2 11920

How to improve the performance of Aggregate transformation?

Dmss,

3 14323

What is critical mapping?

2 11387

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

Accenture,

1 19918

How to view and Generate Metadata Reports?

1 7834

what is difference between COM & DCOM?

Satyam,

1 11206

what is the gap analysis?

1 9514

How to recover sessions in concurrent batches?

3 15743

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

TCS,

3 25302

what is Partitioning ? where we can use Partition?

IBM, TCS,

2 23340

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

6 14279

Where is the cache stored in informatica?

Infosys, Satyam,

5 38226

Un-Answered Questions { Data Warehouse }

Design a mapping to load a target table with the following values from the above source?

1346

How to find the project(pub,priv,common,client) in between public, Private,common?Any identification?

2109

Explain the process of extracting data from source systems,storing in ods and how data modeling is done?

927

Explain absolute filter?

973

Explain pushdown optimization $pushdownconfig parameter - informatica

1141

Which studio is used to create reports?

1108

Mention the procedure via which, we can run Teradata jobs in a UNIX environment.

991

I need a good brd and uc template?

1083

What is informatica?

1155

What are the different table types supported by teradata?

968

Can we start and stop single session in concurent bstch?

941

What is a Query Subject?

1093

Explain the versions of reportnet?

988

can u give example for factless fact table

6649

Where do we use semi and non additive facts?

992

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