Interested to Buy Any Domain ? << Click Here >> for more details...
how can one connect two fact tables ? is it possible ? how?
- 8 Answers
- 37053 Views
- ABC, Oracle, Patni, I also Faced
- E-Mail Answers
Answer Posted / mallika
We can connect two fact tables by using constellation
schema or galaxy schema.
we have 3 types of schemas
star
snowflake
constellation or galaxy
in star schema we have data redundancy.we do not normalize
dimension tables.
in snowflake we normalize dimension tables to reduce space
boyh star aand snowflake we use only one fact and many
dimesion tables.in some situations we have to use more than
one fact table then we use constellation.but its vary
rarely used
| Is This Answer Correct ? | 5 Yes | 6 No |
Post New Answer View All Answers
What is the difference between olap and datawarehosue?
What is the difference between olap and oltp?
What are aggregate tables and aggregate fact tables?
Explain what is a view as it relates to system modeling?
Explain what are the various reporting tools in the market?
What are the approaches used by optimizer during execution plan?
Explain what is a three tier data warehouse?
What is degenerate dimension table?
why we use dmr model in cognos report studio ? give me difference between dmr model and relational model.
Explain difference between e-r modeling and dimentional modeling?
What is a core dimension?
Explain have you ever been in a real dilemma at work? What did you do to get out of it?
What are data modeling and data mining?
Explain when do we analyze the tables? How do we do it?
What is the use of tabular model, tabular sql, tabular reference in real time application?
