Data Warehouse General Interview Questions
Questions Answers Views Company eMail

What is source qualifier?

2 8325

Difference between DSS & OLTP?

IBM,

6 48572

Explain grouped cross tab?

2167

Hierarchy of DWH?

Accenture, EDS, IBM, iFlex, TCS,

2 17438

How many repositories can we create in Informatica?

Informatica,

14 24242

What is surrogate key?

IBM, Informatica,

5 20156

What is difference between Mapplet and reusable transformation?

UST,

3 5602

What is aggregate awareness?

2 6548

Explain reference cursor?

1672

What are parallel querys and query hints?

1760

DWH architecture?

6 16018

What are cursors?

4 7297

Advantages of de normalized data?

2 10181

What is operational data source (ODS)?

2 9247

What is meta data and system catalog?

1829


Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?

493


Explain clustering algorithm?

1820


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

542


Explain the differences between normalizer and normalizer transformation?

498


Is union transormation is active transformation?

559






How are the dimension tables designed?

546


Explain conformed fact?

491


I need a good brd and uc template?

556


What is a fact, dimension, measure?

528


Explain what are the advantages of query studio compared to report studio?

519


What are different deliverables according to phases?

2827


How to get the first 100 rows from the flat file into the target?

647


why we use dmr model in cognos report studio ? give me difference between dmr model and relational model.

1511


How to test report in reportnet?

535


What is the working process for application.cfm?

517