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 are the various types of layout supported by abinitio?

1045

How is the partitioning with key different from round robin partition?

1227

What do you know about partition and also tell us about partition components in abinitio?

1068

What are the functions of the replicate and dedup component?

1107

Tell us about the architecture of abinitio.

1115

In abinitio, what types of parallelism are used?

1106

How can a graph be run infinitely?

1136

Mention some file extensions which are used in abinitio?

1142

What are the differences between informatica and abinitio?

1227

What does de-partition mean in abinitio?

1294

What do you understand by local lookup?

1176

What are the reasons for which business can trust the approach of data processing?

1198

Mention some ways for improving performance of a graph?

1096

What information is provided by .dbc file extension for connecting to the database?

1185

What do you know about abinitio?

1275

Un-Answered Questions { Data Warehouse }

options available in sequence job to run,validate?

1331

What is slibref?

1292

what is epilog tab?

Which development components of informatica have the highest usage?

1068

What is Index Caches size?

1132

Mention what are the different types of parallelism used in abinitio?

1133

What is difference between model & package?

1044

Given an unsorted data set, how to read the last observation to a new data set?

1369

how to create reports on screech?

2571

To which project that prefix will set is to private project or public project or both?how and where to set?

1867

Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?

3640

What type of indexing mechanism do we need to use for a typical data warehouse?

1182

what is the use of proc contents and proc print in sas? : Sas-administrator

1073

What is Indexing? how did u implement indexing?

2491

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

1976

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