Interested to Buy Any Domain ? << Click Here >> for more details...
how can one connect two fact tables ? is it possible ? how?
- 8 Answers
- 37427 Views
- ABC, Oracle, Patni, I also Faced
- E-Mail Answers
Answer Posted / itesh
Yes it’s possible,
Since after all its a table, if you have the proper
relationship no problem,
Conceptually it’s correct to have a have confirmed
dimension but it can be manipulated,
Ex.
I have one fact a table FACT EOD this year i have joined
with EOD FACT Last year with time id .its working fine
Again
If you have two fact table A and B then create a derived
table from B Of the required key and measure only and join
with original fact table A ,
Better check with a sql query.
Nothing is impossible……
Cheers
I
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What are situations where snowflake schema is better than star schema when the opposite is true?
What does level of granularity of a fact table signify?
what is the synchonus? wht is the diff between synchronous and asynchronous what is the diff between v1 and v2 v3 delta modes in sap ecc
Explain where do we use semi and non additive facts?
How to add a number to a macro variable?
What is operational data store (ods)?
how much memory space occupied real time project (roughly)?
What is data analysis?
What is the difference between datawarehouse and bi?
What is the difference between snowflake and star schema?
How to pivot row data using informatica?
What are the various methods of getting incremental records or delta records from the source systems?
What is the difference between mapping parameter & mapping variable in data warehousing?
What are the differences between datamart vs. Reporting cube?
What is "method/1"?
