Answer Posted / rocky!!

Here is another answer.
--> SEQ1
SD --> SQ --> EXP --> EXP --> TGT
--> SEQ2

1) Add SEQ1. Keep Starting value as 1 with cycle attribute set in after end value 100.
2) Add Another SEQ2. This is to keep a tab on the record count on the incoming data flow.
3) Get NEXTVAL & NEXTVAL1 from SEQ1 and SEQ2 and dump it in EXP.
4) in EXP, add Varibale port "V_OUTPUT_DECISION" and write code "CEIL(NEXTVAL1/100)"
5) in EXP, add variable "V_BATCH_NO" and initialise value as 10.
6) in EXP, add output port "OUTPUT_DECISION_BATCH_NO" and write code as "V_OUTPUT_DECISION*V_BATCH_NO"
7) connect fields viz, YEAR, DESC, MONTH, SALARY and BATCHNO to Target.

I guess this is the generic code. Bring any number records, should work.

Cheers!!

Design a mapping to load the cumulative sum of salaries of employees into target table?

1555

---

Difference between Target-based loading and constraint-based loading?

1042

---

How to convert multiple rows to single row (multiple columns) in informatica

1426

---

expain about the tune parameters?

2457

---

What is the benefit of partitioning a session?

1235

---

How do you load first and last records into target table?

1209

---

What do you mean by filter transformation?

1004

---

what is informatica metadata?

1089

---

 Informatica Checkpoints

3377

---

What is the difference between Active and Passive transformation?

1221

---

What are the different transaction levels available in transaction control transformation?

1274

---

Explain the tuning lookup transformation - informatica

1045

---

How to update a particular record in target with out running whole workflow?

1628

---

Differentiate between a database and data warehouse?

1193

---

What is workflow monitor?

1100

---