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 16460

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

IBM,

1 4244

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

IBM,

1904

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

Bank Of America,

2223

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

Bank Of America,

3253

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

Bank Of America,

2 8091

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

Bank Of America,

1 6626

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

Bank Of America,

4 7743

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

Bank Of America,

4 13820

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

Bank Of America, CTS,

6 22285

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

Bank Of America,

2 7103

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

Bank Of America,

3 8209

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

Bank Of America,

2151

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

Bank Of America,

2109

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

Bank Of America,

2 6346

Un-Answered Questions { Data Warehouse }

Can we have multiple application.cfm file in an application?

1011

What is the difference between dependent data warehouse and independent data warehouse?

1058

What is a hash cluster?

1044

What is the purpose of trailing @ and @@? How do you use them?

1093

Why is auto-regression used in forecasting used on cognos platform?

1075

What does Amp contain and what are all the operations that it performs?

1058

How to create repository in abinitio for stand alone system(local nt)?

1305

Explain can a dimension table contains numeric values?

1022

Explain what are slowly changing dimensions?

1079

How can we increase the loading performance of oracle table in AbInitio?

1217

How will change port of obiee answers?

907

What is meant by active and passive transformation?

1195

what is a prompt value in report studio and variables ?

2781

What is a cube in data warehousing concept?

1145

What is Active Datawarehousing?

1064

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