i am having around 10 transactional(fact) table in my DB. and many other master(dimensional) table. to form schema what is the best way either can i concatenate all transaction tables or any other way?
If all fact tables are having particular KEY field which is common in between all fact then link Key will be better approach may be efficient way to do data modelling..ELSE concatenate all fact in one ..
it will form snowflake schema. i know if i concatenate in to one it will give star schema. star schema will give better result? in optimization it is good?
You need to consider the data quality, granularity and performance. Sometimes the star schema is good sometimes snow flake schema is good in performance. Check out best practices in data modelling to get good performance.
If u concatenate all 10 fact into 1 & build star schema but it will not give better performance. Because you simply adding number of record count into single table. Concatenate into single fact is good for small data size. If data size huge u need to think before simply concate all table.
Hi all thanks for replying my database is little huge. thats why i am asking if i concatenate i will better perfomance or is there any alternate suggestions
