Hi everyone,
I have a load plan in ODI 12c that executes 3 scenarios in an order. These 3 scenarios fetch data from tables in STG schema then load it into tables in STG_HIST schema, and all 3 scenarios use the same variable P_DATE which has its value as a date (in text form).
Since I mean to schedule this load plan to run daily, I declare the P_DATE 's Select Query as:
SELECT TO_CHAR(SYSDATE, 'YYYYMMDD') FROM DUAL
Then I check the Refresh and Overwrite boxes of P_DATE on each of the 3 steps in the load plan (as you can see in the photo above), so that everyday when the load plan runs, the P_DATE's value is refreshed into the date of that day.
I was able to schedule the load plan and it runs successfully, the P_DATE's value also gets changed into ‘20250702’, which is the day the load plan was run.
However, I wonder if it is the valid method to run a mapping with a date variable daily or not? And is there any other way for me to achieve the same result by, let's say, modifying the Select Query in P_DATE?