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

How to extract sap data using informatica?

1049

Explain what are the various etl tools in the market?

950

Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?

952

Explain do we need an etl tool? When do we go for the tools in the market?

1025

Explain do we need an etl tool?

1031

When do we go for the tools in the market?

952

Explain what is etl process? How many steps etl contains explain with example?

900

How many steps etl contains explain with example?

977

Explain and compare etl & manual development?

930

Explain the difference between etl tool and olap tools?

919

What are various etl tools in the market?

1014

What task is 98% of the required work of a business analyst?

1052

Explain what is aggregate table and aggregate fact table ... Any examples of both?

1117

What is aggregate table and aggregate fact table ... Any examples of both?

1072

What are the data types present in bo? What happens if we implement view in the designer and report?

1032

Un-Answered Questions { Data Warehouse }

What is the function of union transformation?

1142

What are the fundamental blocks of co> operating system of ab initio?

1273

--------------Diff b/w ODS and OLAP?

3211

In microstrategy, how can we direct the sql generated to use a specifc table?

1038

Can you define framework manager?

1039

Can you define drill down and drill up?

1039

What do you mean by a transaction file?

1267

what is user variable in affinium campaign? and some real time examples.

4189

How can you limit the variables written to output dataset in data step?

1321

What is the profile and package?

2307

In abinitio, what types of parallelism are used?

1096

Sequence generator, when you move from develoment to production how will you reset

2052

How co> operating system natively processes the data?

1107

What are the differences between a connected lookup and unconnected lookup?

1075

Explain the difference between rolap and molap?

988

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