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 tracing level and what are the types?

958

Can there be sub steps of etl steps?

1028

What are the etl testing operations includes?

1111

What are the various tools used in etl?

1044

What is partitioning? Explain different types of partitioning?

1241

What do you understand by active and passive transformations?

940

What are the names of the layers in etl?

1001

What are the different etl testing categories as per their function?

1076

how many steps are there in etl process?

979

What is meant by incremental load?

1096

Compare etl & elt?

1012

What dedup-component and replicate component does?

1274

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

1362

What is the role of co-operating system in abinitio?

1446

What is a look-up?

1256

Un-Answered Questions { Data Warehouse }

When using multiple dml statements to perform a single unit of work, is it preferable to use implicit or explicit transactions, and why?

1151

What is the effect of dls on microstrategy?

1005

What do you mean by mstr? What are the different types of mstr objects?

1017

How online/offline mode impact development and delpoyment?

832

What is the difference between %local and %global? : sas-macro

1189

What is the data type of the surrogate key?

1004

What is depict expression change?

1120

What is an object prompt in microstrategy?

1008

There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?

1113

What is the roundrobin collector?

1099

What is the difference between sandbox and EME?

1267

What is the difference between an operational datastage and a data warehouse?

1154

Can you explain cognos tm1?

Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?

2061

how to create user defined function (udf) in informatica

1307

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