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

Explain the difference between a data warehouse and a data mart?

782

---

Parameter and variable differences

1806

---

where to store informatica rejected data?

837

---

How to do unit testing in informatica? How to load data in informatica ?

861

---

I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1502

---

---

What is meant by pre and post session shell command?

840

---

How do you convert single row from source into three rows into target?

854

---

Write the unconnected lookup syntax and how to return more than one column.

819

---

What is transformation?

864

---

How to configure mapping in informatica?

868

---

What are mapplets? How is it different from a Reusable Transformation?

828

---

How do we call shell scripts from informatica?

760

---

can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2304

---

Define joiner transformation?

786

---

What is data transformation manager process?

806

---