DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
rumu
Participant



Joined: 06 Jun 2005
Posts: 296

Points: 2948

Post Posted: Sun Nov 08, 2020 5:05 am Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi All,

We are in the requirement gathering phase and creating Technical design document, while designing the Job Restartability we need to include data clean strategy for partial load in case of job failure.
We will use ODBC connector stage to connect to Oracle db(as per cleint), so while loading data using ODBC connector stage, can we opt for Record Count=0 keeping array size to a default value? Will Record count=0 ensure that no data will commit to the database in case job failed?

Regards,
Rumu

_________________
Rumu
IT Consultant
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54621
Location: Sydney, Australia
Points: 296179

Post Posted: Fri Feb 12, 2021 3:04 am Reply with quote    Back to top    

Yes it will.

But you may have to get on good terms with your DBA, because that might results in some quite sizeable transactions!

_________________
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours