Answer Posted / gattu srinivasarao
FactTable:It consists of th efacts and references of the diminision tables.
Diminsion table:It consists only charchter values,for example cus_name,cus_add,etc..
| Is This Answer Correct ? | 6 Yes | 4 No |
Post New Answer View All Answers
How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?
Explain what is metadata reporter?
What is degenerate dimension table?
Explain what is a staging area? Do we need it? What is the purpose of a staging area?
Explain the main differences between star and snowflake schema?
What is is a star schema?
Explain reference cursor?
Explain the structure of cold fusion?
Which are the olap tools available that are supported by oracle?
explain about balanced dimension,
what is difference between drill & scope of analysis?
What are partition points?
Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?
can anybody mail me the FAQS for hyperion essbase amd planning
How to create different types of templates?