Modify stage or transformer stage

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

Post Reply
kavuri
Premium Member
Premium Member
Posts: 161
Joined: Mon Apr 16, 2007 2:56 pm

Modify stage or transformer stage

Post by kavuri »

Hi,
I am getting input as 64bit data from a DB2 database and I need to convert it into 32bit into the text file. What stage is good to use modify stage or transformer stage or anyhting else is there.

Thanks in advance.

Kavuri
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Modify stage, Transformer stage, External Filter stage, Build stage, to name a few.

What will you do if the 64-bit quantity is too large to fit into a 32-bit field? Do you have a plan/design for this? Probably the Transformer stage is best in this case, because you can include IF tests, for example on the input value, in order to decide which conversion and downstream processing stream is the most appropriate for each input row.
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