Copy Stage is it needed

Brett · Post by **Brett** » Mon May 09, 2011 7:33 pm

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.

Brett · Post by **Brett** » Mon May 09, 2011 9:16 pm

Thanks for the feedback - i was just curious.

Sorry for the post to the wrong forum as well

Brett.

Bicchu · Post by **Bicchu** » Thu May 12, 2011 12:58 am

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.

Bicchu · Post by **Bicchu** » Thu May 12, 2011 12:59 am

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.