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?

1052

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

1034

What are some examples of informatica etl programs?

954

Describe data concatenation?

1090

Define the various join types of joiner transformation?

997

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

1009

How to use pmcmd utility command?

1048

What is the session task and command task?

1070

How we can create indexes after completing the loan process?

1224

What is a standalone command task?

1217

What is the advantage of informatica?

1078

What are the transformations that are not supported in mapplet?

1045

Does an informatica transformation support only aggregate expressions?

1053

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

1436

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

1054

Un-Answered Questions { Data Warehouse }

What all are the different way to run a job?

1103

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1922

Explain teradata utilities. What is multiload, fast load, tpump?

1020

what are the cubes developed in a sap bw project and what is the requirement for developing it?

2096

What's the difference between timestamp (0) and timestamp (6)?

1204

What is the basic syntax of a sas program?

1226

Hi friends, I am trying to create OLAP connection in IDT. I am getting error "error code:405 METHOD NOT ALLOWED" I am using "http:/olap/msmdpump.dll" I am using ms sql server 2012 -- cube

3853

Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks

2037

The question was on time stamp. what is the difference between HH and HH24 when to use when.

2069

What are the different components of powercenter?

1068

What is substr in informatica?

1219

What is an Integration service in Informatica?

1146

Which command is used to save logs in the external file?

1115

What is grain of fact?

992

Explain the difference between etl tool and olap tools?

926

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