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

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1756

---

design of staging area?

1986

---

i have a data in my source as a flat files what test i have to perform the next step can any body help to me

2088

---

What is a sequence generator transformation?

987

---

How do you load unique records into one target table and duplicate records into a different target table?

1180

---

How do you use reject loader.

2566

---

What do you understand by a term domain?

1088

---

What is xml source qualifier transformation in informatica?

1189

---

Explain the use of aggregator cache file?

1207

---

Which development components of informatica have the highest usage?

1005

---

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1864

---

What is union transformation in informatica?

1115

---

How can we use batches?

986

---

Target increases every day even though no new record was inserted

1529

---

Can we create multiple integration service on single repository?

1155

---