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
sendmkpk
Premium Member
Posts: 97 Joined: Mon Apr 02, 2007 2:47 am
Post
by sendmkpk » Tue Aug 05, 2008 12:01 am
hi,
i have one fundamental question on buildop.
Can we implement a simple filter condition in buildop.
thnx in advance
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Tue Aug 05, 2008 12:36 am
Yes, but it's total overkill. What the Transformer stage generates (in version 7.5.2 and later, anyway) is essentially an operator (the same as what a BuildOp is).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
sendmkpk
Premium Member
Posts: 97 Joined: Mon Apr 02, 2007 2:47 am
Post
by sendmkpk » Tue Aug 05, 2008 12:53 am
thanxs for reply.
we were just running a perfomance test of builp vs transformer.
so exactly how can we implement a filter condition in buildop.
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Tue Aug 05, 2008 1:10 am
Write the code to transfer conditionally from input to output. There's no particular "how" - it will depend on your particular filtering requirement.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
sendmkpk
Premium Member
Posts: 97 Joined: Mon Apr 02, 2007 2:47 am
Post
by sendmkpk » Tue Aug 05, 2008 2:07 am
i am only aware of "if then else " condition, but through that, i guess we cannot drop records.
pl throw some more light on the details. we just have column_name='xxxx' condition.
thanx for replies.
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Tue Aug 05, 2008 4:00 am
Without a specification there ARE no details. Read the chapter in the manual about Build stages, in particular the piece about managing transfers.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.