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

What are the types of lookup transformation?

1058

---

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

1997

---

What do you mean by enterprise data warehousing?

1038

---

Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

1306

---

What is dimensional table? Explain the different dimensions.

1157

---

how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

2435

---

What are the main issues while working with flat files as source and as targets ?

1141

---

What is the difference between a connected look up and unconnected lookup?

953

---

To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

1093

---

How do you load only null records into target? Explain through mapping flow.

1998

---

What is the maplet?

1092

---

COM components can be used in Informatica

2368

---

What is pmcmd command?

1087

---

How you prepared reports for OLAP?

1586

---

What is a passive transformation?

1080

---