Data Warehouse General Interview Questions
Questions Answers Views Company eMail

What is source qualifier?

2 8366

Difference between DSS & OLTP?

IBM,

6 48716

Explain grouped cross tab?

2183

Hierarchy of DWH?

Accenture, EDS, IBM, iFlex, TCS,

2 17485

How many repositories can we create in Informatica?

Informatica,

14 24417

What is surrogate key?

IBM, Informatica,

5 20226

What is difference between Mapplet and reusable transformation?

UST,

3 5655

What is aggregate awareness?

2 6586

Explain reference cursor?

1687

What are parallel querys and query hints?

1778

DWH architecture?

6 16092

What are cursors?

4 7340

Advantages of de normalized data?

2 10220

What is operational data source (ODS)?

2 9295

What is meta data and system catalog?

1844


Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

Explain what is partitioning? What are the types of partitioning?

507


What are the different types of segments?

534


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

559


How do we design a universe?

514


What are different deliverables according to phases?

2841






Explain the differences between normalizer and normalizer transformation?

511


What are the methodologies of data warehousing?

563


Explain what are non-additive facts?

552


Explain the definition of normalized and denormalized view?

515


Explain what is a cube in data warehousing concept?

545


The same tier?

531


Explain about core dimension,

530


Explain what is analytical or analytic mean?

575


Explain datawarehousing?

547


How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?

539