What will happen if one column mentioned as primary key in DB and other column as primary key in mapping structure in infomratica

What will happen if one column mentioned as primary key in DB and other column as primary key in mapping structure in informatica Powercenter or IICS.

1 answer

  • answered 2022-04-19 17:44 Novneet

    It would not create an issue, as long as it is for reading the data.

    But, if we are going to write the data in the target(using different keys) then Informatica would perform the record operation(I/U/D) on the basis of the key defined in Informatica.

How many English words
do you know?
Test your English vocabulary size, and measure
how many words do you know
Online Test
Powered by Examplum