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

Suppose we do not group by on any ports of the aggregator what will be the output?

1048

What are the advantages of using informatica as an etl tool over teradata?

1032

What are some examples of informatica etl programs?

953

Describe data concatenation?

1089

Define the various join types of joiner transformation?

994

What are the new features of informatica 9.x in developer level?

1007

How to use pmcmd utility command?

1046

What is the session task and command task?

1069

How we can create indexes after completing the loan process?

1221

What is a standalone command task?

1213

What is the advantage of informatica?

1077

What are the transformations that are not supported in mapplet?

1040

Does an informatica transformation support only aggregate expressions?

1050

What are the different ways to implement parallel processing in informatica?

1434

What are the new features of informatica 9.x at the developer level?

1052

Un-Answered Questions { Data Warehouse }

What are the types of containers?

1248

What are attribute roles?

986

Mention few capabilities of sas framework.

1200

How can we remove the duplicates from flat file source?

1049

How to select multiple values from type-in prompt?

1068

how do you deploy a report in cognos 8 to run in maximo6? what r the steps in maximo??

2427

Explain do we need an etl tool? When do we go for the tools in the market?

1029

what kind of system requirement is needed to run tm1 for a small installation?

Why update strategy and union transformations are active? Explain with examples.

1250

Explain fact relation?

1029

Can you implement SCD2 using join, transformer and funnel stage?

1562

What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?

2163

What are transforms and what is the differenece between routines and transforms?

1071

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1716

What are sequencers?

1124

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