question

We want to create a partition for master table on cut-off_date column. But the child tables do not have this cut-off date column. They have an ID column. The child tables are linked to master tables through another bridge table & this bridge table includes the ID column & Cut-off_Date column. Now we want to Partition the child tables also based on the cut-off date but since there is no direct mapping of cut-off_date of Master Table with child table, can we create a partition on child tables using some look-up function(which will be referring to one of the tables) without adding any extra column of cut-off_date in the child tables. We want to know any possible methods that will not involve any schema changes on the DB. Please suggest in case of any other better approaches.