DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
This topic has been marked "Resolved."
Author Message
koti9
Participant



Joined: 09 Nov 2005
Posts: 50

Points: 502

Post Posted: Wed Sep 20, 2017 5:46 am Reply with quote    Back to top    

DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Hello,

I am trying to bulk load the data, i also overrided the APT_ORACLE_LOAD_OPTIONS with "OPTIONS(DIRECT=TRUE,PARALLEL=TRUE)", however its not working, when i check the explain plan in Oracle(target db), its always going to Conventional Path though i set Direct Path as True. Did anyone face this? Please let me know.
Thanks for your help in advance.

Thanks & Regards
Koti
chulett

Premium Poster


since January 2006

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

Joined: 12 Nov 2002
Posts: 42164
Location: Denver, CO
Points: 216472

Post Posted: Wed Sep 20, 2017 6:44 am Reply with quote    Back to top    

What stage are you using? How is it configured? I'd also be curious if your target table is actually "bulk loadable"... primarily that it has no indexes.

_________________
-craig

Dr. Frankenstein entered a bodybuilding competition and discovered he had seriously misunderstood the objective.
Rate this response:  
Not yet rated
koti9
Participant



Joined: 09 Nov 2005
Posts: 50

Points: 502

Post Posted: Wed Sep 20, 2017 7:07 am Reply with quote    Back to top    

Hi Craig,

I am using Oracle Connector Stage. I put the bulk load option on and no indexes. Please let me know if you faced this.


Thanks & Regards
Koti
Rate this response:  
Not yet rated
koti9
Participant



Joined: 09 Nov 2005
Posts: 50

Points: 502

Post Posted: Thu Sep 21, 2017 3:54 pm Reply with quote    Back to top    

I was able to use "DIRECT=TRUE" explicitly in sqlldr command using external target, by taking the input from dataset using 'data=\"-\"' i.e.stdin
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