Data Warehouse General Interview Questions
Questions Answers Views Company eMail

What is source qualifier?

1 4760

Difference between DSS & OLTP?

IBM,

5 28070

Explain grouped cross tab?

1255




Hierarchy of DWH?

Accenture, iFlex, IBM, EDS, TCS,

2 12165

How many repositories can we create in Informatica?

Informatica,

14 14093

What is surrogate key?

IBM,

5 13128

What is difference between Mapplet and reusable transformation?

UST,

3 1855

What is aggregate awareness?

2 3859




Explain reference cursor?

794

What are parallel querys and query hints?

894

DWH architecture?

6 10430

What are cursors?

4 4022

Advantages of de normalized data?

2 7408

What is operational data source (ODS)?

2 5749

What is meta data and system catalog?

835


Post New Data Warehouse General Questions






Un-Answered Questions { Data Warehouse General }

Explain Association algorithm in Data mining?

604


what are the others of "bad files" and "discard files" when using sql*loader?

655


What are algorithms provided by Microsoft in SQL Server?

702


Difference between PowerPlay transformer and power play reports?

1070


What is Analysis Services?

713


In general, how many Fact & Dimension tables are present in a Banking Data warehouse project ?

840


What is meta data and system catalog?

835


How did you plan your Data ware house project?

802


What are parallel querys and query hints?

894


Explain clustering algorithm?

752


what are the other factors of the database on which the loading performance depend?

529


can anybody mail me the FAQS for hyperion essbase amd planning

4213


What is MODEL is Data mining world?

1198


for data loading in oracle, what are conventional loading , what are conventional loading and direct-path loading?

634


What are different deliverables according to phases?

1898