Nested Parameters in Informatica

Question

I want to see number of affected rows of my target table. For that, I can write a shell script in which I pass a parameter as $PM@numAffectedRows. However, if my target table name is parameterized and I want to pass that in the same shell, how can I do that?

Eg. $ParamTgtTable=myTable When I pass $PM'$ParamTgtTable'@numAffectedRows in the shell script, it echos myTable@numAffectedRows. If I pass the same without the quote as $PM$ParamTgtTable@numAffectedRows, I get $ParamTgtTable@numAffectedRows as my output.

Is there any workaround for this? Appreciate your help on this.

Answer 1

As per my understanding, the 'parametrized target name' you've mentiond refers to 'Target Table' property on Target Transformation. What you need to use is the latter: name of the Target Transformation. This is something where parameters are not allowed.