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
- 15334 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
How to configure mapping in informatica?
Is stop and abort are same in informatica?
What are the guidelines to be followed while using union transformation?
Which files are created during the session rums by informatics server?
What is target designer and target load order?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What is the benefit of session partitioning?
Can we create a Integration service without a Repository service and vice versa?
What does role playing dimension mean?
Explain about cumulative Sum or moving sum?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What are the advantages of informatica?
Clarify the aggregator change?
