About loading performance

chanthou_2000 · Post by **chanthou_2000** » Thu Jun 19, 2003 3:30 am

Hi all,

i posted an answer the 06/16/2003 to Steven about a loading
solution (topic : "loading performance") by using the sqlplus
command : copy. So i was wondering if someone has already
experimented this command and found that it's faster than DS for
loading rows with a lof of columns (>70) with an advantage :
avoid overloading of rollback segement in Oracle !

(sorry for my english ...)

Thanks

Chanthou

vmcburney · Post by **vmcburney** » Thu Jun 19, 2003 3:50 pm

The copy is useful in situations where no transformation, mapping or validation is required. The Oracle copy command takes the data straight from the source server to the destination server. DataStage transfers the data to the DataStage server, passes it from input stage to the output stage and then onto the destination server. Obviously the allure of transformation means the copy command does not get a lot of use on DataStage projects but it's still a handy command.

Vincent McBurney
Data Integration Services
www.intramatix.com