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

Comment on significance of oracle 9i in informatica when compared to oracle 8 or 8i?

1 4847

Explain about the concept of mapping parameters and variables ?

HCL, TCS,

3 13299

what is mystery dimension?

1 5901

what are cost based and rule based approaches and what is the difference?

1 5461

Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?

2 8047

what is the difference between stop and abort?

TCS,

3 16568

What is Micro Strategy? Why is it used for?

Infosys,

5 25483

what is the difference between Informatica 7.1 and Abinitio?

TCS,

1 9434

what is the logic will you implement to laod the data in to one factv from 'n' number of dimension?

3 7138

What is exact use of 'Online' and 'Offline' server connect Options while defining Work flow in Work flow ?

1 5405

what are the real time problems generally come up while doing or running mapping or any transformation?

2 7042

Explain one complecated mapping?

Fidelity, Wipro,

3 15104

Explain the flow of data in Iinformatica?

1 9829

What does dependency analysis mean in Ab Initio?

Syntel,

5 29529

How to Create Surrogate Key using Ab Initio?

IBM,

6 32674

Un-Answered Questions { Data Warehouse }

What Is Snow Flake Schema?

1204

Explain about alerts in bos, under what situation we need to use alerts?

1051

CHANGE CAPTURE

1298

how many reports have u created ? explain a few.

2098

how would u estimate the size of Lookup transform data and index cache?

2128

Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?

958

What is surrogate key? Where we use it? Explain with examples.

1027

Explain are data mart and dwh normalized or denormalized? Do both of them exist in

1033

List out all forms of LOCKS that are available in Teradata.

968

how can I test reports in cagnos?

1153

What is Cognos script editor?

2554

Suppose I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can I do it and drag it onto report editor?

1060

why use references rather than pointers in the public api, particularly for arguments which are modified?

1005

Explain the methods to improve performance of a graph?

1107

How to include or exclude specific variables in a data set?

1120

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