Repair Full Request
In a scenario, ODS1-->ODS2 update happens. What I also want to achieve is bring a whole lot of data selectively (selected on ODS1 fields) repeatedly from ODS1 to ODS2 (to overwrite certain derived values, as these keep changing).
So, regular process
: Delta of ODS1>ODS2 (OK already)
Additional required process : ODS1(Full, selected on year-say,)-->ODS2
If I create a 'Repair full request' Infopackage for this requirement, would it bring data from changelog table or from main ODS1 table (my intent is to bring data from active ODS1 table)?
Since the target is also ODS, it is not a problem if records are being added multiple times to the target.