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
After we create a scd table, can we use that particular dimension as a dimension table for star schema?
How can we do data cleaning?
Compare and contrast aggregates & indexes
What is difference between model & package?
How to pivot row data using informatica?
I have two universes created by two difference database can we join them in designer & report level? How
Explain the data types present in bo n wht happens if we implement view in the designer n report?
What are the key features of chameleon that separates it from other algorithms?
What is loop in data warehousing?
What are the different types of join operations?
Explain what are components of reportnet?
what is user variable in affinium campaign? and some real time examples.
Compare cold fusion with other programming languages?
What is the difference between metadata and data dictionary?
What are the types of SCD?