Interested to Buy Any Domain ? << Click Here >> for more details...
how can one connect two fact tables ? is it possible ? how?
- 8 Answers
- 37640 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 are the advantages and disadvantages of using stored procedures versus calling sql inline in cold fusion?
Where the applications and where ware house management system is used?
Difference between cold fusion mx 6 and cold fusion mx 7?
What are the types of partitioning?
What are the different methods of loading dimension tables?
How do you setup Lo-cockpit?
What are the fundamental elements of the data warehouse?
What is difference between query studio and report studio?
Explain differences between star and snowflake schemas?
How can we acheive correlated sub-query in designer?can anyone help me in this regard?
What is the function of etl when used in data warehousing?
Explain the data types present in bo n wht happens if we implement view in the designer n report?
What is vdl (view definition language) explain?
Explain er diagram?
Explain what are the advantages and disadvantages of reporting directly against the database?
