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?

1101

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

1086

What are some examples of informatica etl programs?

993

Describe data concatenation?

1129

Define the various join types of joiner transformation?

1047

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

1061

How to use pmcmd utility command?

1080

What is the session task and command task?

1117

How we can create indexes after completing the loan process?

1253

What is a standalone command task?

1259

What is the advantage of informatica?

1129

What are the transformations that are not supported in mapplet?

1089

Does an informatica transformation support only aggregate expressions?

1090

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

1492

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

1114

Un-Answered Questions { Data Warehouse }

Mention what is rollup component?

1187

What is the function you would use to transfer a string into a decimal?

1286

Difference between zabo and webi?

1155

How do you create surrogate key using ab initio?

1058

Name any two stages of the data processing cycle and provide your answer in terms of a comparative study of them?

1176

how to run turbo integrator process from command line?

Can you define fan trap?

1322

What are the various indexes in teradata? Why are they preferred?

1058

Which sql query platform are you using to communicate with redshift?

Explain Quality stage?

1216

How to read multiple files using a single datastage job if files have the same metadata?

1308

How to sort the dynamic objects alphabetically on the Universe based on and SQL Server

2352

What is an i-server?

1118

What is a passive transformation?

1155

Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.

2009

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