how can one connect two fact tables ? is it possible ? how?
- 8 Answers
- 35155 Views
- ABC, Oracle, Patni, I also Faced
- E-Mail Answers
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
Explain what are components of reportnet?
What is scd1 , scd2 , scd3?
What are data validation strategies for data mart validation after loading process?
What is the use of incremental aggregation? Explain me in brief with an example?
what is difference between drill & scope of analysis?
Suppose your client wants to ensure only specific users can create reports in query studio with other users creating reports using report studio. How can this be accomplished?
Explain what are the modules in power mart?
What is the difference between olap and datawarehosue?
Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar
What is Discover and Execute in XMLA?
Explain dimensional modelling?
explain about balanced dimension,
What are components of report studio?
What is conformed fact?
Store (and count) non-fact records?
