Page 1 of 2

Copy stage active or passive?

Posted: Thu Nov 24, 2011 11:32 pm
by pandeesh
It's not pretty clear in the documentation, whether copy is active or passive.
It's mentioned that processing stage.So can we consider that active stage?

Thanks

Posted: Thu Nov 24, 2011 11:46 pm
by ray.wurlod
Open its properties in the Repository (Stage Types branch) for a definitive answer.

Posted: Thu Nov 24, 2011 11:54 pm
by pandeesh
it's under processing in repositary.So i guess it's active

Posted: Thu Nov 24, 2011 11:56 pm
by kamtammystuff
Its Passive

Posted: Fri Nov 25, 2011 6:23 am
by manoj_23sakthi
Its Passive

Posted: Fri Nov 25, 2011 1:39 pm
by ray.wurlod
Ask yourself this question - is there any way that a Copy stage can change data? (Dropping columns and renaming columns are not changing data.)

Posted: Fri Nov 25, 2011 1:55 pm
by pandeesh
Thanks All!

Posted: Wed Jan 04, 2012 10:52 am
by pandeesh
Today again, I have come across this and one of the experienced person told copy is active stage since it resides under processing category in palette.
I explained her. But she was not at all ready to accept.
I leave it as per her choice ..

Posted: Wed Jan 04, 2012 12:33 pm
by qt_ky
The stage type properties show Copy (PxCopy) as Active, whereas the stage type properties show Sequential File (PxSequentialFile) as Passive.

Posted: Wed Jan 04, 2012 12:36 pm
by qt_ky
All the Processing stage types under the repository show as Active except for the two FTP stages show as Passive.

Posted: Wed Jan 04, 2012 12:55 pm
by pandeesh
By default ,is copy comes under processing category in palette?
I feel since it"s passive ,it should not be under processing category .

Posted: Wed Jan 04, 2012 3:00 pm
by ray.wurlod
You can put it in any folder you like. The repository is entirely customisable. The location of a stage type does not affect its other properties.

Posted: Wed Jan 04, 2012 3:08 pm
by pandeesh
Because, generally people think that whatever reside under processing category are active stages.
That's what happened for copy stage too.

Posted: Wed Jan 04, 2012 3:20 pm
by kaps
I think as someone mentioned above it does not matter where it exists on the pallete. If it changes the number of records/columns when it pass through the stage then it's active otherwise passive.

Posted: Wed Jan 04, 2012 7:57 pm
by ray.wurlod
Not columns. A Copy stage (passive) can quite happily drop (not transfer) some columns. This does not represent a change to the data.