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 is a sequence generator transformation?

1010

---

How to elaborate tracing level?

1166

---

what is $$$$?

2138

---

What is the need for an etl tool?

1062

---

What is a joiner transformation?

984

---

What are the different clients of powercenter?

1052

---

How can you define user defied event?

1022

---

hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

2096

---

What are the data movement modes in informatica?

1145

---

How to create Target definition for flat files?

1211

---

Could you explain what is enterprise data warehouse?

1134

---

What is informatica metadata and where is it stored?

989

---

How can informatica be used for an organization?

1207

---

What are the restrictions of union transformation?

1032

---

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6164

---