Page 1 of 1
Difference between filter stage and constraint
Posted: Thu May 31, 2007 5:12 am
by pdv
What is the difference between filterstage and contraint in tranformer stage which is better and how..?
Re: Difference between filter stage and constraint
Posted: Thu May 31, 2007 5:48 am
by satyanarayana
there is no diff.. in working but... Filterstage as good performance compare to Trans..
Re: Difference between filter stage and constraint
Posted: Thu May 31, 2007 7:29 am
by DSguru2B
satyanarayana wrote:Filterstage as good performance compare to Trans..
That statement does not hold true for versions 7.5 and higher.
Posted: Thu May 31, 2007 8:22 am
by rameshrr3
In A Filter Stage- You cannot use Transform functions on a field and derive constraints based on the result.
But you could possibly use a Transformer stage constraint for almost any kind of Filter that you can set in a Filter Stage.
Posted: Thu May 31, 2007 7:21 pm
by ray.wurlod
Filter stage uses an SQL-like WHERE clause.
Switch stage uses a value.
Transformer stage uses a BASIC-like expression.