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.
- 9 Answers
- 15344 Views
- Barclays, I also Faced
- E-Mail Answers
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
How do you change a non-reusable transformation to reusable transformation?
Describe the impact of several join conditions and join order in a joiner transformation?
What can we do to improve the performance of informatica aggregator transformation?
What is the use of an aggregator cache file?
What does command task mean?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
Why filter transformation is an active one?
What is informatica? Why do we need it?
Is it possible to create multiple domains on a single Informatica server?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
How identifying bottlenecks in various components of informatica and resolving them?
Whats the difference between informatica powercenter server, repositoryserver and repository?
What is the sequence generator transformation in informatica?
What is a joiner transformation and why it is an active one?
What are the differences between joiner transformation and source qualifier transformation?
