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 / suneel reddy
Create triggers in the DataBase on Inserts, use Oracle sequence to generate/fill the surrogate key
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Whats the difference between informatica powercenter server, repositoryserver and repository?
What is the function of aggregator transformation?
How to extract the informatica rejected data?
Why update strategy and union transformations are active?
what is INFORMATICA TESTING process
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
How many ways are there to do 'remove duplicate records in informatica'?
What is persistent lookup cache?
How would you join a node to the already existing domain?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Explain the mapping variable usage example in informatica
what is the difference between informatica6.1 and infomatica7.1
Explain incremental aggregation in informatica
what are factless facts? And in which scenario will you use such kinds of fact tables.
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com