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

What is the difference between the local container and shared container?

1103

What are the repository tables in datastage?

1307

What are the job parameters?

1221

What is the difference between server job and parallel jobs?

1154

What is active and passive stage?

1414

What can we do with datastage director?

1238

What is the difference between datastage and informatica?

1118

What is oci?

1301

What are the components of ascential data stage?

1189

What is the difference between account and directory options ?

1182

What are sequencers?

1115

How and where you used hash file?

1174

What are the types of views in datastage director?

1772

How do you register plug-ins?

962

What is orabulk stage?

1047

Un-Answered Questions { Data Warehouse }

what type of graphs we will create(for 2+years candidates)?

2309

Difference between flat files and relational sources?

2309

What are the functions involved in shared information architecture?

1073

What is meant by junk dimension?

1183

What is spool space? Why do you get spool space errors? How do trouble-shoot them?

986

Define olap designer?

1131

Explain informatica architecture - version 8 / 9

1090

my report ended at the half of the last page but i don't want that matter in the last page I would like to adjust the matter in the previous page .how can i do this?

2006

Why fact table is in normal form?

1251

What are the string manipulation operators and functions associated with teradata?

1090

What are the stages of datawarehousing?

1013

What do you understand by the term 'aggregate cache'?

979

Tell me what is full load & incremental or refresh load?

950

what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.

2238

What is static prompt in microstrategy?

973

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