Need to Optimize data insert mechanism in data stage
Moderators: chulett, rschirm, roy
Need to Optimize data insert mechanism in data stage
It is taking a long time to insert data via datastage in a target database. The target database is Oracle 11g.
I would like to attached the existing properties of Oracle Connector. I am not sure how to upload attachments to a forum.
I would like to attached the existing properties of Oracle Connector. I am not sure how to upload attachments to a forum.
You can't upload anything here. You can, however, have your image(s) hosted at any of the free image hosting websites out there and then link to them here using the "Img" tag.
Please confirm for us you are indeed talking about a Server job and let us know your exact 8.x version.
Please confirm for us you are indeed talking about a Server job and let us know your exact 8.x version.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
You need to have a chat with your DBA about Oracle, bulk loads and indexes. That should help you understand what the various options mean and which you should use. If you don't rebuild the indexes, they can be left in an UNUSABLE state. And as I've noted, even if you do attempt a rebuild, a unique index that you've loaded duplicates to cannot be rebuilt and thus stays UNUSABLE as well.
I just want to make sure you understand that this isn't a "DataStage issue", it's an Oracle sqlldr issue and the best resource in your company if you are unfamiliar with using sqlldr should be your DBA. Hopefully.
I just want to make sure you understand that this isn't a "DataStage issue", it's an Oracle sqlldr issue and the best resource in your company if you are unfamiliar with using sqlldr should be your DBA. Hopefully.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers