Can we implement a simple filter condition in buildop

sendmkpk · 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 · 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).

sendmkpk · 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 · 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.

sendmkpk · 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 · 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.