I have a requirement to frame the below table. Table1 -------- Cust Id Tier Table 2 --------- Cust Id | Week1_Tier|Week2_Tier| Week3_Tier...Week54.
Every week, the Table 2 must get update on the respective columns from Table1. If its Week1, Week1_Tier field must get updated. Week2 , Week2-Tier field must get updated.
Can you throw some design ideas? Thanks, Vj.