| Other Data Warehouse General Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is XMLA ? | | 1 |
| What is data merging, data cleansing and sampling? | | 1 |
| what is data validation strategies for data mart validation
after loading process | | 1 |
| What is factless fact schema? | | 1 |
| How can we import and export using BCP utility? | | 1 |
| suppose data are coming from different locations and those
data will not change . is there any need to use surrogate key ? | Oracle | 3 |
| What is the capacity of power cube? | | 1 |
| What are Fact tables and Dimension Tables? | IBM | 2 |
| Where can one get more info about Data Warehousing? | TCS | 2 |
| wat is code review and wat actually srs or how can we
create HLD,LLD.PLS,GIVE ME ANSWER AS EARLY AS FAST. | | 1 |
| Tell me one example for junk dimension? | TCS | 3 |
| What is Data purging? | TCS | 4 |
| what is a hot file, why we need in datawarehousing, where
we used in general | Thomson | 1 |
| 1.WHAT IS DATA MART ? | HCL | 1 |
| Hierarchy of DWH? | Accenture | 1 |
| What is a look up function? What is default transformation
for the look up function? | | 1 |
| What is difference between Business Objects and Hyperion
Essbase? Please help me | | 1 |
| What is a star schema? Why does one design this way? | | 2 |
| How can you define a transformation? What are different
types of transformations in Informatica? | TCS | 3 |
| How many repositories can we create in Informatica? | Informatica | 7 |
| |
| For more Data Warehouse General Interview Questions Click Here |