What is meant by metadata in context of a data warehouse and how it is important?
What is the difference between ods and oltp?
What are modeling tools available in the market?
What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?
What are the advantages and disadvantages of using stored procedures versus calling sql inline in cold fusion?
Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?
If two relational tables are connected to sq trans, what are the possible errors it will be thrown?
Database in use is oracle?
What is called dimensional modelling?
What are the tools available for etl?
what is difference between Independent Data Mart Dependent Data Mart 1- 1- 2- 2- 3- 3- 4- 4-
Explain a linked cube?
What is Analysis Services?