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
-
sheema
- Premium Member
- Posts: 204
- Joined: Sat Jul 22, 2006 10:20 am
Post
by sheema »
I am reading from a flat file and loading data into a oracle table.below is my job design in datastage 8.5
Sequential File----->Transformer----------->Oracle Connector
I am trying to commit all the rows at once in oracle connector stage.
In order to do that I have set up the below properties in connector
Transaction
Isolation level Read Committed
record count 0
Array size 1
Still i see that all the records are not being inserted at once.
Can you please help me in this regard.
Thanks
Sheema
-
Rob4732
- Premium Member
- Posts: 66
- Joined: Mon Oct 06, 2008 5:14 pm
Post
by Rob4732 »
Try write mode = 'Bulk Load'
thx
We don't see things as they are;
We see them as we are.
-
sheema
- Premium Member
- Posts: 204
- Joined: Sat Jul 22, 2006 10:20 am
Post
by sheema »
I am using Write Mode ------Insert, as i would like to insert my own insert statement, so cannot go with Bulk load.
Thanks
Sheema
-
JJayadeep
- Participant
- Posts: 4
- Joined: Tue Jul 19, 2011 11:18 pm
- Location: India
Post
by JJayadeep »
You can use the AFTER SQL to commit the data at once that has been inserted into Oracle table
-
chulett
- Charter Member
- Posts: 43085
- Joined: Tue Nov 12, 2002 4:34 pm
- Location: Denver, CO
Post
by chulett »
After SQL would be too late.
You need to look into the following APT variables:
$APT_ORAUPSERT_COMMIT_TIME_INTERVAL
$APT_ORAUPSERT_COMMIT_ROW_INTERVAL
-craig
"You can never have too many knives" -- Logan Nine Fingers