Hi,
My requirement is to connect to two different oracle databases using a single oracle enterprise stage or an OCI stage.
Is this possible?
REgards,
Samyam
Connect to Two oracle Servers in a single Oracle stage
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 258
- Joined: Tue Jul 04, 2006 10:35 pm
- Location: Toronto
-
- Premium Member
- Posts: 258
- Joined: Tue Jul 04, 2006 10:35 pm
- Location: Toronto
We have a job which does this operation using two oracle stage.
But the job runs for 3 hrs every day.
Its a simple update insert job with 500 columns and 9 million record.
What i was trying to do here was to push that operation onto the database side rather
then fetching 9 million wide records fron DB to Datastage and then put it into another DB.
just trying to make this job run faster.
Is there anything else i can do to make it run better.
But the job runs for 3 hrs every day.
Its a simple update insert job with 500 columns and 9 million record.
What i was trying to do here was to push that operation onto the database side rather
then fetching 9 million wide records fron DB to Datastage and then put it into another DB.
just trying to make this job run faster.
Is there anything else i can do to make it run better.
Pretty simple to push things to the database side when everything is in the same instance but if you're saying that these are two separate instances then the data still has to come out of one and travel across something to get to the other. It might help to explain your topography in more detail.
Otherwise, have you considered bulk loading the data from the first DB into a work table in the second DB and then using MERGE to perform the update/insert?
Otherwise, have you considered bulk loading the data from the first DB into a work table in the second DB and then using MERGE to perform the update/insert?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Premium Member
- Posts: 258
- Joined: Tue Jul 04, 2006 10:35 pm
- Location: Toronto