Difference between filter stage and constraint

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
pdv
Premium Member
Premium Member
Posts: 23
Joined: Mon Oct 30, 2006 11:58 pm
Location: Chennai

Difference between filter stage and constraint

Post by pdv »

What is the difference between filterstage and contraint in tranformer stage which is better and how..?
satyanarayana
Participant
Posts: 13
Joined: Fri Jul 15, 2005 12:01 am

Re: Difference between filter stage and constraint

Post by satyanarayana »

there is no diff.. in working but... Filterstage as good performance compare to Trans..
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Re: Difference between filter stage and constraint

Post by DSguru2B »

satyanarayana wrote:Filterstage as good performance compare to Trans..
That statement does not hold true for versions 7.5 and higher.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
rameshrr3
Premium Member
Premium Member
Posts: 609
Joined: Mon May 10, 2004 3:32 am
Location: BRENTWOOD, TN

Post 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.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Filter stage uses an SQL-like WHERE clause.
Switch stage uses a value.
Transformer stage uses a BASIC-like expression.
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