Convert mademade table columns to dimension table.

Hi Syndicate_Admin 
The recommended approach is to duplictae the Fact table to create separate dimension tables, from the fact table remove the columns used in Dimension tablels and keep only those which can be used as foreign keys to keep the link between them.

Most of time dimension tables don't get updated frequently, in this case I could create static Dimension tables instead of duplicating the Fact one many times, depends on your use case. 

Did it work ?  ‌‌ Mark it as a solution to help spreading knowledge
Was this exchange helpful? A kudos 👍 would be appreciated