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
- 15387 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 are the types of data warehouses?
Can u generate reports in Informatica?
What is workflow manager?
What is native users?
What is standalone command task?
What are active and passive transformations?
waht type of interface is used for testing the data in informatica
is it possible to index the data in cache of lkp transformation ?
How many numbers of sessions can one group in batches?
Please let me know how to make Data masking in informatica..
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
Explain pushdown optimization and types in informatica
What is xml source qualifier transformation in informatica?
Explain the scenario which compels informatica server to reject files?
Explain how to import oracle sequence into informatica?
