37.2 Required Changes
The following are the prerequisites for Backdated Run Execution:
- Handling Slowly Changing Dimensions (SCDs)
Ensure that all SCD executions for the given prior date or period is happened / completed with valid records in all the SCD dimensions. Record Start Date and Record End Date columns must have values.
- Handling T2T Joins
By default, all out-of-the-box T2Ts have Joins with SCD dimensions using latest record indicator. This must be modified to pick the correct record using Record Start Date and Record End Date columns of SCD dimension.