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 4918

Explain about the concept of mapping parameters and variables ?

HCL, TCS,

3 13434

what is mystery dimension?

1 5989

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

1 5554

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

2 8166

what is the difference between stop and abort?

TCS,

3 16729

What is Micro Strategy? Why is it used for?

Infosys,

5 25802

what is the difference between Informatica 7.1 and Abinitio?

TCS,

1 9518

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

3 7250

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

1 5483

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

2 7153

Explain one complecated mapping?

Fidelity, Wipro,

3 15247

Explain the flow of data in Iinformatica?

1 9913

What does dependency analysis mean in Ab Initio?

Syntel,

5 29754

How to Create Surrogate Key using Ab Initio?

IBM,

6 32904

Un-Answered Questions { Data Warehouse }

What is the difference between reading data from an external file and reading data from an existing data set?

1232

Explain in detail about type 2(scd),

1140

What’s the use AWS redshift cluster Service?

What are the transformations that are not supported in mapplet?

1088

What is the use of datastage designer?

1229

What security is provided with microstrategy desktop?

1018

what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?

1082

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

1000

How to update or delete the rows in a target, which do not have key fields?

1227

What are Aggregate tables?

1229

Difference between Data and Index Caches?

1209

Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?

2283

Nls stands for what in datastage?

1238

How does microstrategy object manager determine if two projects are related?

1114

in reporting we add some new objects,how we get the count of the newly added objects to the report

2254

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