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 13304

what is mystery dimension?

1 5901

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

1 5463

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 25489

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 7139

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 7045

Explain one complecated mapping?

Fidelity, Wipro,

3 15105

Explain the flow of data in Iinformatica?

1 9830

What does dependency analysis mean in Ab Initio?

Syntel,

5 29529

How to Create Surrogate Key using Ab Initio?

IBM,

6 32680

Un-Answered Questions { Data Warehouse }

what are the devoleper roles in real time? plz tell i am new to datastage....

2162

What is a Datastore in Cognos?

1289

Please explain the different stages in creating a report in cognos report net?

1007

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?

2230

What are different table types used in teradata?

1041

What are the different layers in the information server architecture?

1124

what are the day to day activities of teradata DBA ?

5822

where are the log files generally stored.Can you change the path of the file.what can the path be?

2439

What is the difference between dependent data warehouse and independent data warehouse?

1007

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

2261

What is the use of powerplay web viewer in cognos?

1089

If informatica has its scheduler why using third party scheduler?

1268

Explain what are the measure objects?

988

What are the vldb properties? Which level of vldb configurations have the highest precedence?

942

What the difference between “look-up” file and “look is up” in abinitio?

1362

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