Explain reference cursor?
Explain what is fact less fact table? Where you have used it in your project?
What is application.cfm?
What is hash partition?
Explain what are necessary tasks to install reportnet software?
What is the difference between power center and power mart?
Explain what are non-additive facts?
what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.
Explain functional dependency?
What is crass reference table?
Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?
Explain differences between star and snowflake schemas?
waht is the advantage of infoset query