This content has been marked as final. Show 2 replies
There are some steps related to journal. These steps will not be executed unless you use CDC or SCD. So ODI is using the steps as per the necessity.
It also depends on the option you set in the flow tab for your KM.
For instance you'll have some more steps if you turn the flow control on.
One other point : If your three schemas are on the same database, you shouldn't use a LKM. Just define one dataserver for this database with multiple physical schemas. Then grant a select (and insert, update, delete if needed) privs to the schema used for connection in the dataserver definition.
You'll improve performance.