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

-----------Diff b/W Aggregate Function and Rollup Aggrigate Function?

IBM,

1 16310

----------0Diff b/w Report Functions and Database functions?

IBM,

1 4099

----------------------What are the User Securities?

IBM,

1803

---------------Tell me about DWH Concepts?

Bank Of America,

2087

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

Bank Of America,

3162

---------- Purpose of Factless Facttable?

Bank Of America,

2 7883

----------------What is meant by DSS?

Bank Of America,

1 6472

----------------------Diff b/w MOLAP and ROLAP?

Bank Of America,

4 7440

-------What are the Adv of Star Schema and Snow Flake Schema?

Bank Of America,

4 13487

-----------Types of Fact Tables?

Bank Of America, CTS,

6 21841

---------------Can we use more than 1 Fact table ?

Bank Of America,

2 6911

-------------What is a Conformed Dimension?

Bank Of America,

3 7888

---------------Describe OLAP Reporting and RDBMS Reporting?

Bank Of America,

2059

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

Bank Of America,

2013

---------------What is Dimension?

Bank Of America,

2 6131

Un-Answered Questions { Data Warehouse }

How do you add default rules in transformer?

1184

How will you generate test data with no input data?

1121

how does sas handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, procs? : Sas programming

993

What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

979

Explain difference between onrow and onread method?

854

How many dimensions are there in informatica?

1032

Input Data: AAABBBCC CCAAABB expected output A3B3C2 A3B2C2 How can I achieve this in Ab initio? where In output count of occurrences should be sorted from high to low

1423

Explain when to use local filter and when to use global filter?

1311

What is the use of cognos decision stream?

1046

Difference between e-r modeling and dimentional modeling?

874

Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?

916

Mention a few of the ETL tools that come under Teradata.

1029

What is a predefined event?

1047

what is the diff. between a link n a union? what is a custom view? what is the use of unlocking a report ? plz answer to these

1978

what is the difference b/w the refresh and buffered data?

2280

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