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

1
votes

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.

2
informaticainformatica-powercenter
Not very clear where you are facing problem. Are your tables in different databases or in different schema in the same database? - Samik
different schema but same database - infa
Then you can create two seperate parameters for the schema names. Is that what you did? - Samik
I created two parameters and placed it in file and added those in mappings tab of session.how to add these two parameters in the properties tab-->$Target connection value - infa
ok. Can you share the exact error you are getting? - Samik

2 Answers

1
votes

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.

0
votes

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.