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

Is olap services sold as a separate product?

921

Name the various types of filters?

947

Compare microstrategy and tableau.

986

How we can decided drilling options for an attribute?

984

Write different kinds of objects in microstrategy?

1001

Name the types of transformation?

954

What are the programs that we can do with the microstrategy architect?

1040

What is a local lookup?

1221

What are the benefits of data analyzing?

1186

What is data encoding?

1260

What is the architecture of abinitio?

1099

What is the syntax for m_dump in abinitio?

1625

List out some of the air commands used in abintio?

1388

What does edp stand for?

1157

What is abinitio?

1174

Un-Answered Questions { Data Warehouse }

what versions of sas have you used (on which platforms)? : Sas programming

1071

Explain what are the vaious etl tools in the market?

943

What are the Types of parallelism in detail?

1142

What is index awareness in universe?

1036

What is meant by lookup transformation?

1110

What are cluster in redshift? How do I create and delete a cluster in aws redshift?

What is the difference between validated and compiled in the datastage?

1293

which date functions advances a date time or date/time value by a given interval? : Sas programming

956

As union transformation gives UNION ALL output, how you will get the UNION output?

1108

What is the difference between fastload and multiload?

1380

Explain data step in SAS

1099

is it possible to index the data in cache of lkp transformation ?

2029

If RDBMS is halted what will you do ?

2168

What is the difference between a cascading report and drill through report?

1072

List few etl bugs?

944

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