How can I maintain unique surrogate key if 2 separate workflow in different repository run at the same time and insert/update the main table. Please let me know how can I achieve the above scenario.

Venkateswara Rao

• Oct 14th, 2014

In this scenario the best approach is to define a sequence in Database (ex :oracle ).. Call in informatica when ever you want . even if it is across multiple repositories it will work.

Mahendra Rajpoot

 Profile Answers by Mahendra Rajpoot Questions by Mahendra Rajpoot

• Sep 17th, 2014

Yes, we can. But we need to export/import the mapplet in different repositories. Working with Mapplets: After you create a mapplet, you can validate or edit the mapplet in the Mapplet Designer. You c...

Answer Question  Select Best Answer