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
- 15688 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 are session parameters ? How do you set them?
Can you generate sequence numbers without using the sequence generator transformation?
What is the function of union transformation?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
How to elaborate powercenter integration service?
Can u generate reports in Informatica?
What are the measure objects?
scenario where i can use only concurrent execution of workflow.
What are the static cache and dynamic cache in informatica?
Where can we find the throughput option in informatica?
How many dimensions are there in informatica?
wat are deployement groups in informatica, how it will be used for developers
Explain sessions and how many types of sessions are there?
How to create a non-reusable instance of reusable transformations?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
