how can one connect two fact tables ? is it possible ? how?
- 8 Answers
- 34753 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
What is called data cleaning?
What is vdl (view definition language) explain?
What according to you might be the future of data warehousing?
What is mean by aggregate aware?
What are the possible data marts in retail sales?
How do we design a universe?
Explain what are necessary tasks to install reportnet software?
What are the stages that are required in data warehousing?
What is vldb(very large databases)?
Where we use surrogate key explain with example?
What are diagrams?
Why fact table is in a normal form?
explain about balanced dimension,
What is surrogate key? Where we use it explain with example?
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.
