Answer Posted / santosh

Please follow the below step.

1.Create sequence geneteor which will start with 1.
2.Connect the nextval port to expression t/p.
3.connect port from sq transformation to expression t/p.
4.Create below port in the expression transformation.
a. NEXTVAL_OUT(Variable port)= NEXTVAL-1
b.rec_con(Variable port)= IIF(NEXTVAL_OUT % 100 = 0, REC_CON+10,REC_CON)
c. REC_CON_OUT(Out put port)= rec_con

5. If you have primary key on the target table then use update startegy t/r to update the targer.
6. If you don't have primary key on the target table then use update voerride in the properties tab of the target.
7. U can use the below query to update the target by update override.
UPDATE EMP_UPDATE SET REC_COUNT = :TU.REC_COUNT WHERE EMPID = :TU.EMPID

Please correct me if anything wrong.

Thanks and Regards
Santosh Kumar Sarangi

In informatica workflow manager, how many repositories can be created?

1262

---

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

1908

---

what is the size of your data warehousing?

2042

---

Explain what is informatica metadata and where is it stored?

986

---

What is the sequence generator transformation in informatica?

1092

---

In development project what is the process to follow for an etl developer from day1

1648

---

What is the difference between router and filter?

1149

---

Can anyone tell me the new features in Informatica 9 Version?

2031

---

Sequence generator, when you move from develoment to production how will you reset

1939

---

What is DR strategy for Informatica project?

1114

---

How many input parameters can exist in an unconnected lookup?

1490

---

How to use pmcmd utility command?

961

---

How to do unit testing in informatica?

1121

---

Separate from an archive server and a powerhouse?

904

---

What are the differences between oltp and olap?

920

---