How can i maintain unique surrogate key if 2 seperate
workflows from different repository run and insert/update the
main table at the same time.

Answer Posted / singam srini

Hi
who replied the answer to given qs.. they were wrong..
please read the qs properly then reply ok..
sameer said same sequence generator..
deepak said reusable transformation(seq gen) and mappet..
how can we implement same seq gen t/r in different repositories..?
is it possible..?

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Design time, run time. If you don't create parameter what will happen

1519


Explain what are the different versions of informatica?

758


What is sequence generator transformation in informatica?

714


I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

901


what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

2020






What are the limitations of joiner transformation?

746


What is update strategy transform?

696


What is the difference between router and filter?

722


Why sorter is an active transformation?

840


Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

906


is it possible to index the data in cache of lkp transformation ?

1625


What are the advantages of informatica?

662


what is Active lock explain

2452


Briefly explain the aggregator transformation?

689


What is the status code in stored procedure transformation?

768