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 / sameer rana

We can maintain a unique surrogate key if we use the same
sequence generator to generate the key.

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many ways a relational source definition can be updated and what are they?

573


-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

4966


What is informatica metadata and where is it stored?

581


Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

776


What is a repository manager?

644






How can we improve session performance in aggregator transformation?

670


What are the features of complex mapping?

639


How can we use mapping variables in informatica?

597


What is domain and gateway node?

690


Can you use flat files in Mapplets.

2213


What are multi-group transformations?

558


Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

629


What is meant by a domain?

623


Define the various join types of joiner transformation?

557


my source is junk data how will u remove that junk data by using unix please any one replay me

3237