Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett , rschirm , roy
pandeesh
Premium Member
Posts: 1399 Joined: Sun Oct 24, 2010 5:15 am
Location: CHENNAI, TAMIL NADU
Post
by pandeesh » Thu Nov 24, 2011 11:32 pm
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
pandeeswaran
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Thu Nov 24, 2011 11:46 pm
Open its properties in the Repository (Stage Types branch) for a definitive answer.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
pandeesh
Premium Member
Posts: 1399 Joined: Sun Oct 24, 2010 5:15 am
Location: CHENNAI, TAMIL NADU
Post
by pandeesh » Thu Nov 24, 2011 11:54 pm
it's under processing in repositary.So i guess it's active
pandeeswaran
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Fri Nov 25, 2011 1:39 pm
Ask yourself this question - is there any way that a Copy stage can change data? (Dropping columns and renaming columns are not changing data.)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
pandeesh
Premium Member
Posts: 1399 Joined: Sun Oct 24, 2010 5:15 am
Location: CHENNAI, TAMIL NADU
Post
by pandeesh » Fri Nov 25, 2011 1:55 pm
Thanks All!
pandeeswaran
pandeesh
Premium Member
Posts: 1399 Joined: Sun Oct 24, 2010 5:15 am
Location: CHENNAI, TAMIL NADU
Post
by pandeesh » Wed Jan 04, 2012 10:52 am
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 ..
pandeeswaran
qt_ky
Premium Member
Posts: 2895 Joined: Wed Aug 03, 2011 6:16 am
Location: USA
Post
by qt_ky » Wed Jan 04, 2012 12:33 pm
The stage type properties show Copy (PxCopy) as Active, whereas the stage type properties show Sequential File (PxSequentialFile) as Passive.
Choose a job you love, and you will never have to work a day in your life. - Confucius
qt_ky
Premium Member
Posts: 2895 Joined: Wed Aug 03, 2011 6:16 am
Location: USA
Post
by qt_ky » Wed Jan 04, 2012 12:36 pm
All the Processing stage types under the repository show as Active except for the two FTP stages show as Passive.
Choose a job you love, and you will never have to work a day in your life. - Confucius
pandeesh
Premium Member
Posts: 1399 Joined: Sun Oct 24, 2010 5:15 am
Location: CHENNAI, TAMIL NADU
Post
by pandeesh » Wed Jan 04, 2012 12:55 pm
By default ,is copy comes under processing category in palette?
I feel since it"s passive ,it should not be under processing category .
pandeeswaran
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Wed Jan 04, 2012 3:00 pm
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
pandeesh
Premium Member
Posts: 1399 Joined: Sun Oct 24, 2010 5:15 am
Location: CHENNAI, TAMIL NADU
Post
by pandeesh » Wed Jan 04, 2012 3:08 pm
Because, generally people think that whatever reside under processing category are active stages.
That's what happened for copy stage too.
pandeeswaran
kaps
Participant
Posts: 452 Joined: Tue May 10, 2005 12:36 pm
Post
by kaps » Wed Jan 04, 2012 3:20 pm
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.
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Wed Jan 04, 2012 7:57 pm
Not columns. A Copy stage (passive) can quite happily drop (not transfer) some columns. This does not represent a change to the data.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.