pradeep

• Jul 5th, 2006

 

You can do a lookup on the target table and check for the rows already present there. Hence the first 300 records will not be reloaded to the target.

Pradeep

Shanmugam

• Jul 5th, 2006

 

You can also use variable to store the rownum of the final row you loaded in the target. From next time you can use this variable to load the rest of the data to the target.

usha

• Jul 6th, 2006

 

You can use a filter transformation and set a condition there as rownum>300

Aparna

• Jul 18th, 2006

 

if ur source is a flatfile, there is an option to specify from which row we want to read the data(used actually to eliminate reading headers)....i don't remeber where ths option is..try the source definition in the source anayser, or in the session properties...

Sureshkumar

• Jul 25th, 2006

 

By using Sequence GeneratorTransformation u can do it

ie by chaging the RESET option in the properties tab of your SequenceGeneratorTransformation.

then it will work

ok bye

kiran

• Jul 26th, 2006

 

Hi

pradep, shanmugum, usha, aparna, sureshkumar

     thanks for ur reply, but here the problem is even though u are storing the rownumber in a variable, and again when ever u start the session the second time it will again read from the begening of the table. it will be waste of server resource. so my point is, is there any solution where in the server can read the from the exact point where it has stopped the previous time.

thanks in advance

kiran

nagaraju

• Aug 3rd, 2006

 

hai

  exact solution of the  problem is  in the  session properties have one check box option "recovery to load target".when it is enable ,it loaded the remaining rows .

abdulla

 Profile Answers by abdulla 

• Aug 19th, 2006

 

hi,

  u can use mapping variable concept for this.

na123

 Profile Answers by na123 Questions by na123

• Aug 22nd, 2006

 

hey kiran,

   u can solve this problem by using mapping variable where u need to mention the start value and end value.

when u end ur session then that variable will take the next value as the start value next time.as u said if suppose first value is 1 and u ended it up at 300 then next time it will take start value as 301.got it!!