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

create a mapping to retrieve the employees who are getting salary greater than average salary?

4 Answers   TCS,

---

How we can create indexes after completing the load process?

0 Answers  

---

what is the diff b/w union and joiner and lookup?

4 Answers  

---

what is surrogate id ?

3 Answers   IBM,

---

When the informatica server marks that a batch is failed?

2 Answers  

---

what is data modelling? what are types of modelling?In which suituation will use each one?

1 Answers   Accenture,

---

Can we create multiple integration service on single repository?

0 Answers  

---

How to load data into 3 target tables which are in different schema but with the same name and same relational connection at infromatica level ? How to differentiate while loading ? and how to load ?

2 Answers   IBM,

---

get me the resultant input:- 1 x,y,z output:- 1 x 2 a,b 1 y 3 c 1 z 2 a 2 b 3 c

3 Answers   Infosys,

---

what is the use of Java Transformation in Informatica 8.x?

2 Answers   TCS,

---

What is the difference between lookup override and souce qualifier override ?

2 Answers   Puma,

---

If a table contains 100 records we have to fetch 50-100 records from source to target?how

7 Answers   CSC,

---