| Other Data Warehouse General Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How Materialized Views are linked with Oracle DataWare
house? | Kirloskar | 1 |
| Difference between DSS & OLTP? | IBM | 2 |
| How many repositories can we create in Informatica? | Informatica | 7 |
| What is XMLA ? | | 1 |
| three ways sql*loader could load data, what are those three
types? | | 1 |
| How can Oracle Materialized Views be used to speed up data
warehouse queries? | | 3 |
| What is Drill by? drill through? | iFlex | 1 |
| What is the difference between OLAP, ROLAP, MOLAP and HOLAP? | | 2 |
| what is data validation strategies for data mart validation
after loading process | | 1 |
| What is the capacity of power cube? | | 1 |
| What is the difference between an ODS and a W/H? | | 1 |
| Can you explain how analysis service works? | | 1 |
| What is the difference between a W/H and an OLTP application? | | 4 |
| what is query optimizer? what are different types of
optimizer s supported by oracle ? | | 1 |
| how can one connect two fact tables ? is it possible ? how? | ABC | 6 |
| How to use the tool Ontobulider | | 1 |
| What is subject area? | | 2 |
| explain the ROLLUP, CUBE, RANK AND DENSE_RANK FUNCTIONS OF
ORACLE 8I | IBM | 1 |
| What is an OLTP (Online Transaction Processing) System? | | 2 |
| what is indexing ? what are different types of indexes
supported by oracle ? | | 2 |
| |
| For more Data Warehouse General Interview Questions Click Here |
Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff 
Site Map
