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
- 13256 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 stop and abort in informatica
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What is joiner transformation in informatica?
Differentiate between router and filter transformation?
What is Index Caches size?
4 yrs etl devloper roles and responsibilities?any body give solutions
What is the function of union transformation?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
Sequence generator, when you move from develoment to production how will you reset
What do you mean by worklet?
What is the difference between a connected look up and unconnected lookup?
Where can we find the throughput option in informatica?
Can we create two repositories on same database instance in oracle?
How we can use union transformation?
How do you load only null records into target?
