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
- 15691 Views
- Barclays, I also Faced
- E-Mail Answers
Answer Posted / sanjeev
Mapping 1: we will use sequence generator, if key value is null then we will pass nextval else will find maximum of key value then will increment by 1
Mapping 2: same as above
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between a connected look up and unconnected lookup?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What are the different types of repositories created using informatica?
What is pmcmd command?
Can we create two repositories on same database instance in oracle?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What is domain and gateway node?
What are the features of complex mapping?
What is informatica? Why do we need it?
What is main use of mapplet?
Explain sql transformation in script mode examples in informatica
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.
What is the use of source qualifier?
expain about the tune parameters?
Reusable transformation and shortcut differences
