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
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What is update strategy transform?
Explain the scenario which compels informatica server to reject files?
How do you take back up of repository?
What is workflow manager?
What does role playing dimension mean?
What is the difference between informatics 7x and 8x and what is latest version?
What is a surrogate key?
without table how to come first record only in oracle?
What are the main issues while working with flat files as source and as targets ?
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
what is unit testing?tell me proceedure
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 ?
What is main use of mapplet?
Can you generate sequence numbers without using the sequence generator transformation?