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

Create a sequence generator transformation in transformation developer and use this transformation instead of using separate sequence generators. 2. Use mapplet and design

Is This Answer Correct ?    3 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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.

1273


I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1761


How do you handle two sessions in Informatica

1152


How to open an older version of an object in the workspace?

1198


How to generate sequence numbers using expression transformation?

1085


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


How do you load only null records into target?

1212


Explain the use of aggregator cache file?

1247


Sequence generator, when you move from develoment to production how will you reset

2028


How do you manage the Parameter files while migrating your data from one environment to another environment?

1013


How can we delete duplicate rows from flat files?

1218


What is an aggregator transformation?

1096


Explain the scenario which compels informatica server to reject files?

1162


What is a repository? And how to add it in an informatica client?

1145


How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1124