Source I am having 600000 records and want to load the all records in to(with out transformations) Target table. Job took 22 minutes.
Pelase suggest how to improve the performance. (Simple load source to target). Already target Table having more then 10 milion records and Primary key constraints but no indexes defined.
Improve Performance
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 251
- Joined: Mon Jun 09, 2008 5:52 am
Improve Performance
Srinu Gadipudi
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
Sure, why not? Worst case, run it on one node, it may still be faster. There's far too little information in the original post to get better answers, so hopefully they'll pony up what you've asked for and whatever else might be helpful.priyadarshikunal wrote:Bulk load in parallel?chulett wrote:perhaps switch to a bulk load.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
-
- Participant
- Posts: 251
- Joined: Mon Jun 09, 2008 5:52 am