Star schema contains only one fact table.
If you have morethan one fact table then if you are going to imploment star schema then concatinate the fact tables into 1 fact table.
Just like this
load * from fact1;
load * from fact2;
load * from fact3;
Thank you Anand,
can you please give me any simple example with sample date how two fact tables will be linked and how can we test combination of links while testing data integrity like combination can i get total output data.
Generally there is one fact table and n dimension tables surrounding it, if you have more than one Fact table, then you can convert to one fact table using concatenate like below
'Sales' AS Flag
'Budget' AS Flag
Or if both are different data then try to generate the data model like below
Flags are used to identify from which Source table the record belongs to, if you don't have this flag you don't have any clue from which table particular row belongs to, since we are concatenating multiple tables. It is a good practice to arrive a flag in script, latest it would be very useful for troubleshooting if there is any issues.
If you got the answer please close this thread by giving Correct Answer to the useful post.