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!!

What is target designer and target load order?

1050

---

How can a transformation be made reusable?

1076

---

What is a filter transformation and why it is an active one?

905

---

How to generate sequence numbers using expression transformation?

1025

---

Separate from a database, an information bazaar, and an information stockroom?

1007

---

What is an unconnected transformation?

1032

---

What is workflow? What are the components of the workflow manager?

1059

---

Describe the impact of several join conditions and join order in a joiner transformation?

1005

---

What is the difference between informatica 7.0 and 8.0?

951

---

what is the hint? how to use it to reduce the query processing in program?

7621

---

tell me 5 session failure in real time how can you solve that in your project?

2181

---

How can you increase the performance in joiner transformation?

1132

---

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1056

---

Why update strategy and union transformations are active?

986

---

What is a dimensional model?

926

---