Half data on each run

Through one session how we load half of data from flat file on 1st run of session and on 2nd run of the same session it load rest half of data to the same target ?

Interview Candidate
Sep 27th, 2011
3
5602

Informatica

Answer

First
Prev
Next
Last

Showing Answers 1 - 3 of 3 Answers

Ankur Mishra

Apr 26th, 2012

Create two session which points to the same mapping and parameterise the source qualifier query in a way that it picks first half record for the first session run and second half for the second session run.For the first session run > will be passed null and for the second session run < will be be passed null.