DataBase loading

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

kennyapril
Participant
Posts: 248
Joined: Fri Jul 30, 2010 9:04 am

Post by kennyapril »

Thanks,

so the stream output can be sent to a copy stage with out output to it
and reject to a table.

can I over write the copy stage each time I run the job?
Regards,
Kenny
mhester
Participant
Posts: 622
Joined: Tue Mar 04, 2003 5:26 am
Location: Phoenix, AZ
Contact:

Post by mhester »

Correct - have no output out of the copy and you will have no issues.
kennyapril
Participant
Posts: 248
Joined: Fri Jul 30, 2010 9:04 am

Post by kennyapril »

thanks for the quick info!!

so I assume everytime I send the rows to copy stage no issue arises as the rows overwrite.
followed the same way,it works!!
Regards,
Kenny
mhester
Participant
Posts: 622
Joined: Tue Mar 04, 2003 5:26 am
Location: Phoenix, AZ
Contact:

Post by mhester »

You are welcome

A copy with no output is not writing anything
kennyapril
Participant
Posts: 248
Joined: Fri Jul 30, 2010 9:04 am

Post by kennyapril »

got you!!
Regards,
Kenny
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Think of it this way. A Copy stage creates N copies of its input, where N is the number of outputs. A Copy stage with zero outputs creates zero copies of its input. But it consumes the input anyway.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply