Hi everyone,
I'm planning to run each day my Load Plan with a list of mappings in it (insert/update).
My target tables in each mapping have a column called TASK_LOG_SID where I plan to store ID number of last successful Load Plan (someting like ETL_CYCLE_ID in Informatica).
Which ODI repo table has this information stored and is there a Substitution API method that could bring me the last successful Load Plan ID?
I'm planning to use ODI variable in Load Plan to get this information using query inside it. I personally think this is the most elegant and simplest solution, but if someone has some better idea I would be glad to discuss it with you. My modified IKM will take this ID inside variable and write it in TASK_LOG_SID column.
Thanks in advance,
Kovar