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 6148

What are the reusable transforamtions?

2 6361

What are the methods for creating reusable transforamtions?

2 6338

What are the unsupported repository objects for a mapplet?

Informatica,

1 9080

What are the mapping paramaters and mapping variables?

1 6085

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

2 7472

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

1 5901

How can yoU improve session performance in aggregator transformation?

TCS,

8 28026

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

2 17418

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

2 10921

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

2 6792

What are the join types in joiner transformation?

Informatica,

1 6581

What are the joiner caches?

Informatica,

3 17888

what is the look up transformation?

Informatica,

2 10059

Why use the lookup transformation ?

Informatica,

2 6780

Un-Answered Questions { Data Warehouse }

What Amazon redshift built for ?

Define Merge?

1374

Differentiate between data file and descriptor file?

1109

Give the advantages of cognos?

1092

What are aggregate tables and aggregate fact tables?

1100

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

2155

What are default access rights in teradata?

1196

What is embedded metric?

1057

What tools would you use for that?

1165

Tell me about Propagate functions in informatica

980

What is looping and how to avoid it in framework manager?

1254

You can ask about different vector functions. How to use in abinitio graph?

5594

How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?

2668

what is universe null

2466

Explain what are the steps to be taken to schedule the report?

1162

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