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
- 14964 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
Can we create a Integration service without a Repository service and vice versa?
What is decode in informatica?
How to elaborate powercenter integration service?
Explain the types of transformations?
What is a router transformation?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Explain joiner transformation in informatica
permutations of mapplet
What are the different versions of informatica?
Explain pushdown optimization $pushdownconfig parameter - informatica
What are the limitations of joiner transformation?
Slowly changing dimensions, types and where will you use them
Explain what transformation and how many are there in informatica?
What is the function of look up transformation?
What are the informatica performance improvement tips
