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
can anyone suggest best free Talend data integration training online
wat are deployement groups in informatica, how it will be used for developers
What are the differences between oltp and olap?
Briefly describe lookup transformation?
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 can we use batches?
Briefly define reusable transformation?
How big was your fact table
How to configure mapping in informatica?
What are the components of Informatica? And what is the purpose of each?
explain abt ur project architecture?
Differentiate between a repository server and a powerhouse?
How do you migrate data from one environment to another?
Write the program through which the records can be updated?
What do you mean by channel change?