Page 1 of 1
datastage concept
Posted: Thu Sep 04, 2008 1:14 pm
by prasson_ibm
Hi all,
I have one job and it has transferred 100 records after that it aborts. I have added one one more record that is 101.Now i want my job to start from 101...for this what i have to do.....?
thanks in advance
Posted: Thu Sep 04, 2008 1:43 pm
by chulett
Add a parameterized constraint to skip the first X records where this time X = 100. And please don't post in all bold, it makes the baby jesus cry.
Posted: Thu Sep 04, 2008 7:45 pm
by vmcburney
But fortune favours the bold.
Posted: Thu Sep 04, 2008 8:14 pm
by chulett
D'oh! :D
Posted: Fri Sep 05, 2008 7:38 am
by chpraveen.msc
Gurus,
I Agree with your answer. But we need to configure it manually. Apart from capturing the record count and reloading the records from the point where it got aborted. Is there any way that Datastage will handle the situation on its own(with out keeping track of the records or by giving the Parameter contraint as said by chulett).
Posted: Fri Sep 05, 2008 7:40 am
by chpraveen.msc
Gurus,
I Agree with your answer. But we need to configure it manually. Apart from capturing the record count and reloading the records from the point where it got aborted. Is there any way that Datastage will handle the situation on its own(with out keeping track of the records or by giving the Parameter contraint as said by chulett).
Posted: Fri Sep 05, 2008 5:51 pm
by ray.wurlod
No. Somewhere it must keep track. Otherwise there's no way to establish the restart point.
Posted: Sat Sep 06, 2008 5:05 am
by prasson_ibm
Hi all
thanks a lot for ur replies.....