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 16396

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

IBM,

1 4163

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

IBM,

1856

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

Bank Of America,

2151

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

Bank Of America,

3208

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

Bank Of America,

2 7985

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

Bank Of America,

1 6532

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

Bank Of America,

4 7610

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

Bank Of America,

4 13690

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

Bank Of America, CTS,

6 22068

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

Bank Of America,

2 6998

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

Bank Of America,

3 8060

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

Bank Of America,

2106

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

Bank Of America,

2047

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

Bank Of America,

2 6250

Un-Answered Questions { Data Warehouse }

What is the difference between ods and oltp?

1027

Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?

1955

How can you link a query to a data container manually in Report Studio?

2360

Explain what is sort component in abinitio?

1105

Explain what is the difference between stop and abort?

1046

Explain what is difference between query studio and report studio?

993

Differentiate between datastage and informatica?

1186

What are the components of the report studio?

1182

Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?

1029

What is index awareness in universe?

1036

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1711

what is a security filter?

999

Explain the difference between using drop = data set option in set and data statement?

1159

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

982

How to RD using transformer?

1428

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