We will look here at some of the details of how ODI uses multiple substitution rounds to replace some of the code within KMs with the actual code that will be ultimately executed by the databases and scripts.
To follow along with the examples listed here, you will need an ODI project with at least the following KMs:
LKM File to SQL (SQLLDR) and
IKM SQL Control Append. From a resource perspective, you will need a
Flat File model with at least one file defined and an Oracle model with at least one table.
LKM File to Oracle (SQLLDR)KM, to
LKM File to Oracle (SQLLDR) with substitutions.
LKM File to Oracle (SQLLDR) with substitutionsKM and within the step ...