37.3 Recommendations

Modifying T2T Joins using Record Start Date and Record End Date columns causes poor performance due to comparison of multiple dates in the query. The following are the recommendations:

1. Copy the existing T2T definitions and modify the Joins to pick Record Start Date and Record End Date instead of latest record indicator.
2. Copy Record Start Date and Record End Date of the existing FSDF Process (under Run Rule Framework) which loads T2T and replace them with new T2T definitions changed above.

3. Whenever a backdated Run is required, modify the Run definition without changing the Run ID to pick the modified Process.

   Note:

   It is recommended to use this only when there is Backdated Run requirement. Any normal sequential days execution can be performed using out-of-the-box T2Ts and Runs as it results in better performance.