Maintaining Data Integrity

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.

Questions by abhiastra   answers by abhiastra

Showing Answers 1 - 4 of 4 Answers

Mahendra Rajpoot

  • Sep 16th, 2014
 

This can be achieved,

1. Create a sequence generator transformation in transformation developer and use this transformation instead of using separate sequence generators.
2. Use mapplet and design sequence generator logic. Use this mapplet in the mappings.
3. Or Use 1 sequence generator to load odd numbers surrogate key and other to load even numbers.

  Was this answer useful?  Yes

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 can also use the Designer to copy mapplets, export and import mapplets, create shortcuts to mapplets, and delete mapplets from the repository.

  Was this answer useful?  Yes

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.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions