| Other Data Warehouse General Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| 5.Explain ODS ? | HCL | 3 |
| how can one connect two fact tables ? is it possible ? how? | ABC | 7 |
| 1.WHAT IS DATA MART ? | HCL | 4 |
| three ways sql*loader could load data, what are those three
types? | | 1 |
| difference between For each and for all | | 1 |
| Advantages of de normalized data? | | 2 |
| in siebel analytics by using dashboard prompts in a page
have 2 reports so i have to give dashboard prompt to applied
on first report only that will not applied to 2 report how
it will do | IBM | 1 |
| what is table partitioning? How it is useful to warehouse
database? | EDS | 1 |
| What is BCP? | | 1 |
| How to use the tool Ontobulider | | 1 |
| What is ?Data Warehousing?? | | 2 |
| What is Drill by? drill through? | iFlex | 1 |
| capital of tamilnadu | Wipro | 1 |
| why oracle is the best database for data warehousing? | HCL | 2 |
| How can Oracle Materialized Views be used to speed up data
warehouse queries? | | 3 |
| How can we import and export using BCP utility? | | 1 |
| What is the capacity of power cube? | | 1 |
| 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 query optimizer? what are different types of
optimizer s supported by oracle ? | ABC | 1 |
| What is a Data Cube? | | 1 |
| |
| For more Data Warehouse General Interview Questions Click Here |