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 the goal of optimizer?
Explain swot analysis?
Explain the data types present in bo n wht happens if we implement view in the designer n report?
what are different storage options supported by oracle ?
Explain what is the limit to the number of sources and targets you can have in a mapping?
Explain what are the advantages of query studio compared to report studio?
Explain a linked cube?
What are vaious etl tools in the market?
How to calculate fact table granularity?
What are the stages of datawarehousing?
What are the various transformation available?
Explain the different types of data warehousing?
Suppose if a session fails after loading of 10,000 records in to the target.how can you load the records from 10001 the record when you run the session next time?
What are the different types of segments?
What is the difference between constraind base load ordering and target load plan?