Interested to Buy Any Domain ? << Click Here >> for more details...
how can one connect two fact tables ? is it possible ? how?
- 8 Answers
- 37421 Views
- ABC, Oracle, Patni, I also Faced
- E-Mail Answers
Answer Posted / nethaji
Yes,We can connect two fact tables by using confirmed
dimension indirectly or directly by confirmed fact.Here when
a fact appears in more than one fact table we can join using
this fact.
eg:
fact table 1 fact table 2
------------ ------------
measures maesures
revenue <=======> revenue
| Is This Answer Correct ? | 5 Yes | 12 No |
Post New Answer View All Answers
Compare aggregates and data marts
Define Data Warehousing?
Explain differences between star and snowflake schemas?
How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?
Where the applications and where ware house management system is used?
Can decision tree be implemented using SQL?
Suppose we want to display zero when null values coming to report how can we do that?
What is Cognos script editor?
What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?
Difference between e-r modeling and dimentional modeling?
Explain difference between view and materialized view?
How many clustered indexes can u create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
How can you clear the cache?
What is the main difference between schema in rdbms and schemas in datawarehouse?
ware house management system is used?
