Data Warehouse General Interview Questions
Questions Answers Views Company eMail

What is source qualifier?

2 6021

Difference between DSS & OLTP?

IBM,

6 36601

Explain grouped cross tab?

1494




Hierarchy of DWH?

Accenture, iFlex, IBM, EDS, TCS,

2 14046

How many repositories can we create in Informatica?

Informatica,

14 16769

What is surrogate key?

IBM,

5 15988

What is difference between Mapplet and reusable transformation?

UST,

3 2912

What is aggregate awareness?

2 4774




Explain reference cursor?

1027

What are parallel querys and query hints?

1122

DWH architecture?

6 12272

What are cursors?

4 4901

Advantages of de normalized data?

2 8386

What is operational data source (ODS)?

2 7109

What is meta data and system catalog?

1055


Post New Data Warehouse General Questions






Un-Answered Questions { Data Warehouse General }

What are algorithms provided by Microsoft in SQL Server?

929


What is Discrete and Continuous data in Data mining world?

1403


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

1080


How do you setup Lo-cockpit?

1945


Theare is a Database In analysis services,How we will specify the fact table.(i.e whether we will create the measure objects for the fact tbl.) or it will reside insde the database.

827






How are models actually derived?

863


Hi, i want to do certification in datawarehouse?? which certification is best in current trend?? pls mention the cost also if u can....

1222


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

1600


Compare aggregates and data marts

1487


Explain grouped cross tab?

1494


How did you plan your Data ware house project?

1040


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

962


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

907


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

1103


Explain Association algorithm in Data mining?

904