Explain difference between e-r modeling and dimentional modeling?
What is a Data Cube?
Explain what is power center repository?
What is data warehosuing hierarchy?
How to know the time taken for particular report execution?
Explain the data types present in bo n wht happens if we implement view in the designer n report?
How many repositories can we create in Informatica?
Why null values are mapped as 0 in fact tables?
Where can one get more info about Data Warehousing?
Compare and contrast aggregates & indexes
Explain what are slowly changing dimensions?
What is subject area?
Explain what is the difference between olap and datawarehosue?