Page 1 of 1
Can we implement a simple filter condition in buildop
Posted: Tue Aug 05, 2008 12:01 am
by sendmkpk
hi,
i have one fundamental question on buildop.
Can we implement a simple filter condition in buildop.
thnx in advance
Posted: Tue Aug 05, 2008 12:36 am
by ray.wurlod
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).
Posted: Tue Aug 05, 2008 12:53 am
by sendmkpk
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.
Posted: Tue Aug 05, 2008 1:10 am
by ray.wurlod
Write the code to transfer conditionally from input to output. There's no particular "how" - it will depend on your particular filtering requirement.
Posted: Tue Aug 05, 2008 2:07 am
by sendmkpk
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.
Posted: Tue Aug 05, 2008 4:00 am
by ray.wurlod
Without a specification there ARE no details. Read the chapter in the manual about Build stages, in particular the piece about managing transfers.