Why do you want to create like this
Anyway when you execute the ODI, automatically everything you will find in the ODI logs
Normally when you use static or flow control and check KMs E$_<TargetTableName> is created either at the staging or Target schema. Would that not work?
E$_<TargetTableName> works fine for me .
Thank you for your help and taking out time to response my query.
Glad that worked out