Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Data Warehouse General Interview Questions
Questions Answers Views Company eMail

What is source qualifier?

2 7661

Difference between DSS & OLTP?

IBM,

6 46191

Explain grouped cross tab?

2020

Hierarchy of DWH?

Accenture, EDS, IBM, iFlex, TCS,

2 16636

How many repositories can we create in Informatica?

Informatica,

14 22060

What is surrogate key?

IBM, Informatica,

5 19155

What is difference between Mapplet and reusable transformation?

UST,

3 4933

What is aggregate awareness?

2 6081

Explain reference cursor?

1509

What are parallel querys and query hints?

1605

DWH architecture?

6 14895

What are cursors?

4 6588

Advantages of de normalized data?

2 9751

What is operational data source (ODS)?

2 8708

What is meta data and system catalog?

1677


Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

How to reduce warnings?

356


Explain what is the difference between datawarehouse and bi?

341


Explain what is the difference between power center & power mart?

338


What is the difference between metadata and data dictionary?

357


What is pre-emptive and non-pre-emptive?

384






How can we run the graph? What is the procedure for that?

328


Explain about core dimension, balanced dimension, and dirty dimension?

345


What is the main difference between inmon and kimball philosophies of data warehousing?

422


What is real-time datawarehousing?

413


Describe the differences between a data warehouse and data mart.

332


What are the advantages and disadvantages of using stored procedures versus calling sql inline in cold fusion?

365


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

367


What is conformed fact?

425


Who needs data warehousing?

368


What are modeling tools available in the market?

389