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
- 15404 Views
- Barclays, I also Faced
- E-Mail Answers
Answer Posted / rajesh aitha
Hello all,
We can use one Seq by creating reusable transformation in one repository folder and make the repository folder as shared folder.
But one constraint is there the in the question is all about to maintain the uniq key, being a challenge.
I have a suggestion to append a string for each record that is to maintain as S.key in the mapping it self.
like wf -1 will insert 1234A and wf -2 will insert 1235B as uniq key.
I suggest to know the exact functionality of Seq ...:-)
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What can we do to improve the performance of informatica aggregator transformation?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
How to update a particular record in target with out running whole workflow?
Performance tuning( what you did in performance tuning)
How are the sources and targets definitions imported in informatica designer?
How to join three sources using joiner?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What is persistent lookup cache?
What is rank transformation?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
How would you copy the content of one repository to another repository?
update strategy transformation in informatica
What is the function of look up transformation?
What are the main issues while working with flat files as source and as targets ?
How to join three sources using joiner? Explain though mapping flow.
