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
What are the design methods of data warehousing?
How to get the first 100 rows from the flat file into the target?
How to design file watch jobs?
What are the different types of datawarehosuing?
How to calculate fact table granularity?
Explain multivalued dependency?
How to create diff. Types of templates?
How to limit the max no of rows retrieved in the report?
What is a data profile?
What are diagrams?
What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
Tell me what is full load & incremental or refresh load?
What are parallel querys and query hints?
Suggest a good author for hyperion in data warehousing?
Explain can a dimension table contains numeric values?