Hi all, i have 20 tables which all are fact table and linked through keys and each table have date fields. now i want to link all date fields in to master calendar
Note: all table fields start with table name as prefix for all the fields, only the key columns wont have table prefix.
example:
table1:
key
table1_feild1,
table1_date,
table1_yr
table1_month;
table2:
key
table2_feild1,
table2_date,
table2_yr
table2_month;
Now how to link all these date fields to master calender
