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
- 13251 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 you use flat files in Mapplets.
Explain pmcmd command usage in informatica
Why update strategy and union transformations are active? Explain with examples.
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
What is the use of an aggregator cache file?
Write the different tools in the workflow manager?
How can we use mapping variables in informatica? Where do we use them?
What is informatica? Why do we need it?
How to do the error handling of if ur source is flatfiles?
lookup transformation with screenshots
design of staging area?
what is SDLC way of code development?
What are the different versions of informatica?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
