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

Different sorts of metadata that stores in the storage facility?

1010

How might you approve all mappings in the archive all the while?

1018

Quickly characterize reusable change?

1119

What do you mean by channel change?

1044

What is abap? What are idocs?

965

How can we use external procedural logic in informatica?

923

Do we need an etl tool?

1007

What is etl process. How many steps etl contains explain with example?

958

What is a staging area? What is the purpose of a staging area?

885

What are vaious etl tools in the market?

1004

What are the measure objects?

1202

What are the different types of transformation available in informatica.

1105

Explain what are the different types of transformation available in informatica.

1147

What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

1079

How to do unit testing in informatica? How to load data in informatica ?

1120

Un-Answered Questions { Data Warehouse }

What are the main issues while working with flat files as source and as targets ?

1154

What are the types of Data Warehouse applications?

1024

How a server job can be converted to a parallel job?

1094

how many types of dimensions are available in informatica?

1098

what do the mod and int function do? What do the pad and dim functions do? : Sas programming

1170

What is a router transformation?

1128

What is called partitioned primary index (ppi)?

1013

Difference between multiload and tpump?

1103

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2744

I have a reports on cognos ep7series version3 with database SQl2000.Now i am migrating database SQL2000 to SQL2005.Then What happens to cognos reports and also there is reports cubes then how can i handle this problem please give me step by step solution b'coz i am new to cognos ep7series

2101

any difficulitis have you phase while creating bo reports and how did u solve it

3450

What are the components used in smp and massively parallel processing (mpp) machines?

1057

How many types of joins are there in teradata?

976

How do I create and delete a cluster in aws redshift?

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

1013

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