how can one connect two fact tables ? is it possible ? how?
Answer Posted / dinesh
Two fact tables can connect thru constellation schema. It
is different from Star and snowflake schemas. In
constellation schema , we can join to fact tables
surrounded by dimensions.
| Is This Answer Correct ? | 9 Yes | 6 No |
Post New Answer View All Answers
What is pre-emptive and non-pre-emptive?
How to generate iqd file from framework manager?
What is prompt types of prompts?use of prompts syntax of prompt?
What is the difference between static cache and dynamic cache?
what are relationships?
Explain clustering algorithm?
How to create context?
How to pivot row data using informatica?
What we will do with the universe for faster process?
Explain dimension table ?
Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar
What are loops in Datawarehousing?
What is real-time datawarehousing?
Code the tables statement for a single-level (most common) frequency?
Whether dimension table can have numeric value?