What is the difference between drill through and masterdetail reports?
How can you implement many relations in star schema model?
What are universe requirements?
Explain why denormalization is promoted in universe designing?
What is difference macros and prompts?
Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?
Why fact table is in a normal form?
What is data type of the surrogate key?
What does level of granularity of a fact table signify?
Explain when do we analyze the tables? How do we do it?
What is dimensional modelling?
what is difference between drill & scope of analysis?
What is the extension of file to save template?
What is conformed fact?
Explain what are the various file formats involved in reportnet?