Hi All,
I have an issue loading data into an Oracle Enterprise stage.
If i try to load the data into a txt file job runs in about 2 mins.
If I use an Oracle enterprise stage to load the data using Generated Update Only Option it takes about 2hrs.
Job Design:
Oracle Enterprise-->Trnsfrmr-->Oracle Enterprise(Generated Update Only)
Thanks in advance!!!
Issue loading data using Oracle Enterprise stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 41
- Joined: Sat Jun 06, 2009 11:13 pm
- Location: Kolkata
The table could be in load pending state. In that case you may need to release it. I would also like to know which database you are using. I mean to say if you are using a native stage for database loading then it would give better performance. Indexing on the update key column may also play a vital role in the performance. If available you may also go for a connector stage for table load purpose.
Nayan
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Given that the subject specifies "using Oracle Enterprise stage" I would hazard the guess that the database is Oracle.nayanpatra wrote:I would also like to know which database you are using.
![Wink :wink:](./images/smilies/icon_wink.gif)
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.