Answer Posted / santosh kumar sarangi

create a sequence t/r and link the next value with sq t/r to
expression t/r and. Create two link.
First Link:
Connect ex t/r to update strategy t/r and keep condition as
IIF(NEXTVAL<4,DD_DELETE,DD_REJECT) and connect to target
except the nextval column.
Second Link:
Connect to sorter t/r and sort with descending order of
nextval and rename as in_nextval. create new sequence
generator and link to the same ex t/r. Link the ports to
again one more update strategy t/r and keep the same condition
as IIF(NEXTVAL<4,DD_DELETE,DD_REJECT) and link to the one
more instance of target table.

Let me know if any things wrong.

Thanks & regards,
Santosh Kumar Sarangi

What does update strategy mean, and what are the different option of it?

1092

---

How does a sorter cache works?

1071

---

What is difference between a gateway node and worker node?

1141

---

What are the new features of informatica 9.x at the developer level?

1043

---

How can a transformation be made reusable?

1171

---

How to join three sources using joiner? Explain though mapping flow.

1147

---

What are the differences between source qualifier and joiner transformation?

1062

---

Global and Local shortcuts. Advantages.

2034

---

How can you validate all mappings in the repository simultaneously?

1371

---

how tokens will generate?

2204

---

How to do the error handling of if ur source is flatfiles?

1968

---

i have a data in my source as a flat files what test i have to perform the next step can any body help to me

2123

---

difference between informatica 8.1.1 and 8.6

3677

---

What is DR strategy for Informatica project?

1190

---

In which transformation you cannot drag ports into it?

1320

---