Page 1 of 1
Copy Stage is it needed
Posted: Mon May 09, 2011 7:33 pm
by Brett
In a job I can take a sequential flat file and connect it straight to a DB load stage or it has been suggested I can/should place a copy stage between them. Is there any benefit to this ? . Both methods work and the straight connection seems fine ?
Asking out of interest
Thanks Brett.
Posted: Mon May 09, 2011 9:16 pm
by Brett
Thanks for the feedback - i was just curious.
Sorry for the post to the wrong forum as well
Brett.
Posted: Thu May 12, 2011 12:58 am
by Bicchu
Moreover using a copy stage between a sequential file stage and a db2 target stage helps in the job performance. As some times reading speed of sequential file stage and writing speed of db2 stage is not same and in such a scenario copy stage acts as a buffer. This helps in job performance if we are dealing with millions of data.
Pratik.
Posted: Thu May 12, 2011 12:59 am
by Bicchu
Moreover using a copy stage between a sequential file stage and a db2 target stage helps in the job performance. As some times reading speed of sequential file stage and writing speed of db2 stage is not same and in such a scenario copy stage acts as a buffer. This helps in job performance if we are dealing with millions of data.
Pratik.