Data Warehouse General Interview Questions
Questions Answers Views Company eMail

What is source qualifier?

2 6763

Difference between DSS & OLTP?

IBM,

6 40544

Explain grouped cross tab?

1698

Hierarchy of DWH?

Accenture, iFlex, IBM, EDS, TCS,

2 15042

How many repositories can we create in Informatica?

Informatica,

14 18728

What is surrogate key?

IBM, Informatica,

5 17415

What is difference between Mapplet and reusable transformation?

UST,

3 3752

What is aggregate awareness?

2 5340

Explain reference cursor?

1241

What are parallel querys and query hints?

1327

DWH architecture?

6 13280

What are cursors?

4 5479

Advantages of de normalized data?

2 9015

What is operational data source (ODS)?

2 7747

What is meta data and system catalog?

1379


Post New Data Warehouse General Questions






Un-Answered Questions { Data Warehouse General }

What is Cognos script editor?

1510


What is metadata in context of a datawarehouse?

83


What are fact, dimension, and measure?

87


Can we take backup when the database is opened?

96


What is data cleaning? How can we do that?

90






Explain what is the difference between stop and abort?

80


"A dimension table is wide but the fact table is deep," explain the statement in your own words.

126


Explain what are the various reporting tools in the market?

85


Explain difference between e-r modeling and dimentional modeling?

86


Suppose a null dataset with 10 variables; I want to print only name of the varibales in log window and also output window. How can we do this one?

88


Explain the difference between filter and conditin?

88


What should I have in mind when building olap solution from scratch?

80


Explain what is the metadata extension?

93


Theare is a Database In analysis services,How we will specify the fact table.(i.e whether we will create the measure objects for the fact tbl.) or it will reside insde the database.

1037


Is there any default username & pwd for bo designer & supervisor?

81