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 functional & architectural differences between business objects and web intelligence reports?

2422

Explain is it the job of a business analyst or systems analyst to draw the class diagram?

1041

Explain about a task that really tested your analytical abilities?

1260

Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?

1160

Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?

1060

Explain the data types present in bo and what happens if we implement view in the designer and report?

1037

Explain is data mart?

1029

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

1108

Explain what sort of existing documents should business analysts refer to when starting on a new project?

1015

Difference between b.o 5.1 and 6.1b?

1265

What is the difference between absolute and relative div positioning?

1059

How do you call a module named �testmod.cfm� with the parameters param1=�yes� and param2=5?

1016

How can we acheive correlated sub-query in designer?can anyone help me in this regard?

950

What is the working process for application.cfm?

1051

Is there any rownum object from which we can do this?

949

Un-Answered Questions { Data Warehouse }

What are situations where snowflake schema is better than star schema when the opposite is true?

984

Difference between flat files and relational sources?

2248

What’s the use of redshift?

Explain what are the advantages of query studio compared to report studio?

1026

What are aggregate tables and aggregate fact tables?

1044

What is a mapping?

995

can anyone explain me about retail domain project in informatica?

7952

What you mean by drill across?

1028

How many transformations can be used in mapplets.

1944

what is the difference between cubes and package in cognos

4958

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2731

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

1322

My table got locked during mload due to a failed job. What do I do to perform other operations on it?

1106

Explain the shared cache and re-cache?

1127

How to delete data which is not in source table?

1350

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