Answer / zer0

I guess this should work ........

Source --> SQ --> Exp --> Filter --> Exp --> Target
|
|
SG

Firstly create a mapping variable say $$count and give it
the default value 5.
Create a port in Expression say Srno. and connect the
sequence generator to it (so that it will mark the rownums).
Then in Filter place the condition Srno = $$count
In the second Expression create an extra port and give it
the value SETCOUNTVARIABLE($$count) (this will increment
the mapping variable).
Next time the job runs it will take value of $$count as 6
and so on ........

Kindly revert if this worked ........

What are the tasks that Loadmanger process will do?

1 Answers  

---

How to load the name of the current processing flat file along with the data into the target using informatica mapping?

0 Answers   Informatica,

---

Can we create out put ports in source qualifier t/r?

5 Answers   TCS,

---

What are the restrictions of union transformation?

0 Answers  

---

HI Experts, What is BULK mode and NORMAL mode, Which one gives better performance. How? Please Explain with an example...! It will help's me a lot. Thanks In advance.

8 Answers   CTS,

---

Is it possible to revert a global repository to local one and why?

0 Answers  

---

I am using Informatica 7.1.1. and i used emails task for getting emails but not able to get emails is there any settings in Informatica installation level?

1 Answers  

---

How to delete first 3 rows & last 3 rows in target table in informatica

6 Answers   TetraSoft,

---

Scenario is like this: Name Sal A 10; B 20; C 30; Then Output should be Name Sal A 10; B 20; C 30; Total 60; Use SQL For this scenario

4 Answers   TCS, Wipro,

---

What happens to map if we alter the datatypes between source and its corresponding source qualifier?

0 Answers  

---

What is Session and Batches?

0 Answers   Informatica,

---

In ur current projectu have done any performance tuning of mappings?

1 Answers  

---