Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
How to work on two or more fact tables in our model ....?
can anyone tell me best solution to create best datamodel?
Help me...
Ramaya.
Hi
Please refer below link to understand
one solution would be to have 1 fact table (by concatenating) the data of the two facts into one.
other solution would be a link table between the two fact tables.
there are other Solutions as well
there is no "best" solution. it depends on many things
Thanks for your reply,
Kindly give practical explanation and etc.....
Please...
Ramaya.
a Little bit difficult without further info
if you have fact table 1 you Need to concatenate fact table 2
Fact1:
concatenate
load *
resident Fact2
drop table Fact2
But you Need to have the same Name for the common Dimension (at least you should rename them in the Facts so they are identical ´,- e.g Dim1 in both fact tables and not Dim1 in one and DIm1a in other)
can you post sampe qvw?
Hi
Please refer below link to understand
Thank you Mayil Vahanan Ramasaamy.....
it's more helpful......
Ramaya
No problem. Close this thread