| Other Data Warehouse General Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is the difference between Oracle Express and Oracle
Discoverer? | | 1 |
| what is a hot file, why we need in datawarehousing, where
we used in general | Thomson | 2 |
| Which is the optimized method of extracting the data. | | 1 |
| What is confirmed dimension? | | 5 |
| What is the difference between a W/H and an OLTP application? | | 4 |
| what are different types of partitioning in oracle ? | | 2 |
| Difference between DSS & OLTP? | IBM | 4 |
| what are different ways of loading data to data warehouse
using oracle? | | 1 |
| why oracle is the best database for data warehousing? | HCL | 2 |
| which automation tool is used in data warehouse testing? | | 1 |
| what is the difference between DSS and ODS ? | Satyam | 2 |
| What is the difference between a data warehouse and a data mart? | | 7 |
| How to handle time period attribute for time dependent data??
a.)add time period as a part of pk b.)add time period simply
and make it nullablec.)add time period simply and make it
not null. | IBM | 1 |
| What is Snow Flake Schema design in database? | | 2 |
| how do you use commit frequencies? how does it affect
loading performance? | | 1 |
| How can you define a transformation? What are different
types of transformations in Informatica? | TCS | 4 |
| What is ETL process in Data warehousing? | | 2 |
| What is Time Series algorithm in data mining? | | 2 |
| What is operational data source (ODS)? | | 2 |
| What is an OLTP (Online Transaction Processing) System? | | 3 |
| |
| For more Data Warehouse General Interview Questions Click Here |