Enabling Bulk Mode in DRS
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 232
- Joined: Fri Aug 04, 2006 1:20 am
- Location: Bangalore
Enabling Bulk Mode in DRS
In one of the post, i have read that we can enable bulk loading in DRS Stage also. Can you please explain , how to do it?
-
- Premium Member
- Posts: 232
- Joined: Fri Aug 04, 2006 1:20 am
- Location: Bangalore
The topic is here
Even It is ok, to call some extra jobs or scripts in the before job subroutine to enable bulk mode. But , it is new to me, So need some examples.
Code: Select all
The dynamic RDBMS Stage takes advantage of the native interface of the database. You can also load data in bulk mode.
PeopleSoft's EPM delivers hundreds of jobs to move data from the ERP applications to the different layers of data warehouse. Only one version of each job is delivered. It can be deployed on different database platforms by setting a project level enviornmental variable that tells the RDBMS stage which driver to use at runtime.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Read that as meaning that you can load data in bulk mode if you use some other stage type than Dynamic RDBMS stage - that is, one of the bulk loader stage types.The dynamic RDBMS Stage takes advantage of the native interface of the database. You can also load data in bulk mode.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 232
- Joined: Fri Aug 04, 2006 1:20 am
- Location: Bangalore
You're missing the point. You don't "enable" it, there's nothing to enable. For bulk loading you have basically two choices:
1. You use one of the Bulk Loader stages. For example, for Oracle you could use the 'Oracle OCI Load' a.k.a. the ORAOCIBL stage in 'automatic' mode.
2. You do it the old fashioned way - generate a 'data file' and optionally whatever in the way of 'control' files you need and then you script a call to the native bulk loader. Continuing the Oracle analogy, build the .dat and .ctl files then call sqlldr.
1. You use one of the Bulk Loader stages. For example, for Oracle you could use the 'Oracle OCI Load' a.k.a. the ORAOCIBL stage in 'automatic' mode.
2. You do it the old fashioned way - generate a 'data file' and optionally whatever in the way of 'control' files you need and then you script a call to the native bulk loader. Continuing the Oracle analogy, build the .dat and .ctl files then call sqlldr.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Premium Member
- Posts: 232
- Joined: Fri Aug 04, 2006 1:20 am
- Location: Bangalore
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: