Bulk load
Moderators: chulett, rschirm, roy
Bulk load
Hi,
I am using bulk load option in oracle connector on target side and enable partition on source side. I am getting around 30 million records on source side. I just curious to know is there any better way to do transfer in efficient way.
Thank you,
I am using bulk load option in oracle connector on target side and enable partition on source side. I am getting around 30 million records on source side. I just curious to know is there any better way to do transfer in efficient way.
Thank you,
Bhanu
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If this is Oracle to Oracle you may find that doing the whole thing within Oracle using Oracle utilities is faster.
You may still choose to initiate/control that from DataStage.
If you prefer to use DataStage to design the approach, and you have Balanced Optimizer licensed, try using Balanced Optimizer to (design new jobs that) push some or all of the logic into Oracle.
You may still choose to initiate/control that from DataStage.
If you prefer to use DataStage to design the approach, and you have Balanced Optimizer licensed, try using Balanced Optimizer to (design new jobs that) push some or all of the logic into Oracle.
Last edited by ray.wurlod on Wed Jun 26, 2013 6:25 pm, edited 1 time in total.
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.
Re: Bulk load
If you are doing any transformation, then write the output in to a text file and find any way to load that file using bulk load command.
I did the same approach in SQL Server.
I did the same approach in SQL Server.
Thanks
Ram
----------------------------------
Revealing your ignorance is fine, because you get a chance to learn.
Ram
----------------------------------
Revealing your ignorance is fine, because you get a chance to learn.
Hi Ray,ray.wurlod wrote:If this is Oracle to Oracle you may find that doing the whole thing within Oracle using Oracle utilities is faster.
You may still choose to initiate/control that from DataStage.
If you prefer to ...
Could you please guide me in that direction, how can I initiate/control from DataStage?
Thank you,
Bhanu
Re: Bulk load
Do you mean first write the entire data to a text file and then load into the oracle table ?SURA wrote:If you are doing any transformation, then write the output in to a text file and find any way to load that file using bulk load command.
I did the same approach in SQL Server.
Thank you,
Bhanu
-
- Participant
- Posts: 62
- Joined: Thu Feb 08, 2007 6:01 am
- Location: Pune
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: Bulk load
Yes mine will be a good only if you forced to do some transformation in the Datastage. Otherwise What Ray / others mentioned (to use oralce alone) would be good.bond88 wrote:Do you mean first write the entire data to a text file and then load into the oracle table ?
Thanks
Ram
----------------------------------
Revealing your ignorance is fine, because you get a chance to learn.
Ram
----------------------------------
Revealing your ignorance is fine, because you get a chance to learn.