Data Warehouse General Interview Questions
Questions Answers Views Company eMail

What is source qualifier?

2 6380

Difference between DSS & OLTP?

IBM,

6 38347

Explain grouped cross tab?

1577




Hierarchy of DWH?

Accenture, iFlex, IBM, EDS, TCS,

2 14529

How many repositories can we create in Informatica?

Informatica,

14 17366

What is surrogate key?

IBM,

5 16577

What is difference between Mapplet and reusable transformation?

UST,

3 3266

What is aggregate awareness?

2 5022




Explain reference cursor?

1121

What are parallel querys and query hints?

1218

DWH architecture?

6 12715

What are cursors?

4 5122

Advantages of de normalized data?

2 8696

What is operational data source (ODS)?

2 7363

What is meta data and system catalog?

1230


Post New Data Warehouse General Questions






Un-Answered Questions { Data Warehouse General }

Can you describe me a problem you faced when you were trying to load data from R3 system and another system outside sap systems?

1093


What is Discrete and Continuous data in Data mining world?

1512


Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani

1202


What are the different problems that ?Data mining? can solve?

1698


Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar

980






What is MODEL is Data mining world?

1503


Can you brief about the Data warehouse project you worked on?

1333


Compare aggregates and data marts

1571


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

878


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

925


Explain Association algorithm in Data mining?

1085


Is there any difference in testing database and data ware housing?

1507


What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?

4653


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

1053


hi i have 2 users and 4 reports in dashboard.i have to give rights 2 reports for every users. is it possible give the rights in dashboard.if yes plz let me know how is it possible . thanks in advacne for appreciation. bye rohit

1018