Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett , rschirm , roy
sagar deshmukh
Participant
Posts: 103 Joined: Fri Jan 18, 2008 12:55 am
Location: chennai
Post
by sagar deshmukh » Tue Feb 10, 2009 3:19 am
What is oracle bulk load stage?
how it is different from ordinary oracle stage?
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Tue Feb 10, 2009 5:07 am
Oracle bulk load stage is for server jobs, and creates data and control files for sqlldr. What do you mean by "ordinary"?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
sagar deshmukh
Participant
Posts: 103 Joined: Fri Jan 18, 2008 12:55 am
Location: chennai
Post
by sagar deshmukh » Tue Feb 10, 2009 7:48 am
So...Do we need to prepare control files also...?
or DS will prepare and we just need to mention the path...?
vinothkumar
Participant
Posts: 342 Joined: Tue Nov 04, 2008 10:38 am
Location: Chennai, India
Post
by vinothkumar » Tue Feb 10, 2009 8:17 am
DS will prepare datafile and control file. You have to specify the path alone
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Tue Feb 10, 2009 8:46 am
If we're still talking the Server stage, its behaviour depends on the 'mode' setting - Manual or Automatic. Manual means create the .ctl and .dat files and nothing more. Automatic performs the actual load without instantiating those files.
-craig
"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Tue Feb 10, 2009 2:14 pm
However, the job type and forum are "parallel". Would you (sagar) care to re-phrase your question?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.