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 differences between oltp and olap?

972

---

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1279

---

How do you remove duplicate records in informatica? And how many ways are there to do it?

1167

---

What are the different components of powercenter?

1055

---

What do you mean by enterprise data warehousing?

1065

---

if we have a delimiters at unwanted places in a flat file how can we over come those.

2049

---

can we override a native sql query within informatica? How do we do it?

1126

---

How can you differentiate between powercenter and power map?

1091

---

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

1134

---

When do you use sql override in a lookup transformation?

1099

---

What are the databases that informatica can connect to windows?

1053

---

Mention few advantages of router transformation over filter transformation.

1023

---

what are factless facts? And in which scenario will you use such kinds of fact tables.

1810

---

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

1085

---

What are the conditions needed to improve the performance of informatica aggregator transformation?

1094

---