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 15637

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

7 25993

How do you create single lookup transformation using multiple tables?

TCS,

6 44281

Why touse stored procedure in ETL Application?

2 11758

How to improve the performance of Aggregate transformation?

Dmss,

3 14112

What is critical mapping?

2 11245

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

Accenture,

1 19805

How to view and Generate Metadata Reports?

1 7719

what is difference between COM & DCOM?

Satyam,

1 11116

what is the gap analysis?

1 9414

How to recover sessions in concurrent batches?

3 15559

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

TCS,

3 25144

what is Partitioning ? where we can use Partition?

IBM, TCS,

2 23166

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

6 14028

Where is the cache stored in informatica?

Infosys, Satyam,

5 37974

Un-Answered Questions { Data Warehouse }

What are the default statistics for means procedure?

1173

how to remove duplicates using proc sql?

1098

What is set to be Cognos configuration?

979

Where do you see different stages in the designer?

1039

What is grain of fact?

907

On which interface you will be working as a developer?

989

What is decode in informatica?

1079

How can you link a query to a data container manually in Report Studio?

2318

What is difference between webi and infoview?

1169

What are the design features involved in teradata?

981

List out all forms of LOCKS that are available in Teradata.

919

Explain what is a view as it relates to system modeling?

928

Where the data cube technology is used?

912

What do you understand by the term 'aggregate cache'?

925

what is the complex transformation you used in informatica

2532

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