When to use Copy Stage

[Shruthi]

Hi,

I have only two stages in a job, source as sequential file and target as SQL Server. I need to know if we have to use copy stage in between. I remember that we were using copy stages in between any two sources (even for seq file to dataset or seq file to seq file) where there was direct mapping.

Is it required to use Copy stage or not?

[Harini]

We can use copy stage when we want to load our source data into multiple targets, and when store stage does not support multipe links.

[Sreedhar]

Hi,

Between any two passive stages we can add copy stage, to avoid segment failures.

[Ravi.K]

In your scenario, if it is direct mapping then it is not required to use Copy stage. If you want to drop attributes then it is required.

[Shruthi]

Thanks. We will go ahead and use copy stage as the source and target are passive stages.