Parameter file for the mapping having two target table in different schema-informatica

Question

I have defined all the properties in parameter file.

The properties tab in session level properties allows one connection string to specify but i have two target tables in different schema.

If i specify any one connection variable in the target connection its showing error stating that value not specified for other target table connection.

Can anyone help me pls.

Answer 1

You can always specify different connection detials for different targets in Mapping Tab.

Go to Mapping tab-> choose your Target and in connections Pane you can choose existing connection or specify new conneciton parameter.

Answer 2

Instead of giving the target connection in front of '$Target connection value' in Properties tab of the session, you can put both of your connections in two different variables in parameter file and then can specify the respective variable in Mapping tab of the session at respective Connections.