Data Warehouse General Interview Questions
Questions Answers Views Company eMail

What is source qualifier?

2 6171

Difference between DSS & OLTP?

IBM,

6 37243

Explain grouped cross tab?

1523




Hierarchy of DWH?

Accenture, iFlex, IBM, EDS, TCS,

2 14235

How many repositories can we create in Informatica?

Informatica,

14 16964

What is surrogate key?

IBM,

5 16198

What is difference between Mapplet and reusable transformation?

UST,

3 3029

What is aggregate awareness?

2 4864




Explain reference cursor?

1066

What are parallel querys and query hints?

1155

DWH architecture?

6 12436

What are cursors?

4 4979

Advantages of de normalized data?

2 8507

What is operational data source (ODS)?

2 7212

What is meta data and system catalog?

1112


Post New Data Warehouse General Questions






Un-Answered Questions { Data Warehouse General }

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?

4585


How to handle multi value dimensions?

1117


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

954


Difference between PowerPlay transformer and power play reports?

1349


How did you plan your Data ware house project?

1063






What is Discover and Execute in XMLA?

1106


in general which algorithms for used?

866


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

1257


what is parallel query?

941


How do you setup Lo-cockpit?

1976


What is meta data and system catalog?

1112


Can decision tree be implemented using SQL?

944


does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com

4790


Explain clustering algorithm?

1046


What is difference macros and prompts?

1056