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 many ways you create ports?

1 6068

What are the reusable transforamtions?

2 6247

What are the methods for creating reusable transforamtions?

2 6227

What are the unsupported repository objects for a mapplet?

Informatica,

1 9022

What are the mapping paramaters and mapping variables?

1 6007

Can yoU use the maping parameters or variables created in one maping into another maping?

2 7327

Can you use the maping parameters or variables created in one maping into any other reusable transformation?

1 5802

How can yoU improve session performance in aggregator transformation?

TCS,

8 27736

What are the diffrences between joiner transformation and source qualifier transformation?

2 17331

In which conditions we can not use joiner transformation (Limitaions of joiner transformation) ?

2 10820

what are the settiings that u use to cofigure the joiner transformation?

2 6659

What are the join types in joiner transformation?

Informatica,

1 6492

What are the joiner caches?

Informatica,

3 17759

what is the look up transformation?

Informatica,

2 9964

Why use the lookup transformation ?

Informatica,

2 6673

Un-Answered Questions { Data Warehouse }

How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?

1064

TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1868

How can a transformation be made reusable?

1173

What is a Decision Tree Algorithm?

5012

What you mean by drill across?

1024

Explain what are the steps to do to use alerts in bo?

1078

What is the different lookup cache(s)?

1092

State the difference between an operational datastage and a data warehouse?

1136

Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

2295

define prolog tab?

How to create a repository in abinitio for stand-alone system(local nt)?

1131

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

5685

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1641

What is freehand sql?

1054

In Teradata, what is the significance of UPSERT command?

1235

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