Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 / sanjeev

Mapping 1: we will use sequence generator, if key value is null then we will pass nextval else will find maximum of key value then will increment by 1

Mapping 2: same as above

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

1320


What is update strategy transform?

1096


Explain the scenario which compels informatica server to reject files?

1162


How do you take back up of repository?

1158


What is workflow manager?

1038


What does role playing dimension mean?

1044


What is the difference between informatics 7x and 8x and what is latest version?

1083


What is a surrogate key?

1078


without table how to come first record only in oracle?

2250


What are the main issues while working with flat files as source and as targets ?

1150


i have a data in my source as a flat files what test i have to perform the next step can any body help to me

2116


what is unit testing?tell me proceedure

2219


Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

2177


What is main use of mapplet?

1127


Can you generate sequence numbers without using the sequence generator transformation?

1117