Not in or not between condition:
Moderators: chulett, rschirm, roy
Not in or not between condition:
I have a requirement. I need to exclude the ranges and values like below in datastage.
4-10
25-30
80-300
00
null
Any suggestions would be appreciated.
Thanks
4-10
25-30
80-300
00
null
Any suggestions would be appreciated.
Thanks
-------------------------------------------
Kumar
Kumar
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am
I have values coming as above in three different columns.
condition is something like
column 1 column 2 column 3.
4 26 85 ------------>reject
00 4 null -------------->reject
3 26 85 --------------->pass
If any of those values mentioned in the actual post satisfy the above condition i should reject them.
Note: There is an 'AND' condition between the three columns.
Thanks,
condition is something like
column 1 column 2 column 3.
4 26 85 ------------>reject
00 4 null -------------->reject
3 26 85 --------------->pass
If any of those values mentioned in the actual post satisfy the above condition i should reject them.
Note: There is an 'AND' condition between the three columns.
Thanks,
-------------------------------------------
Kumar
Kumar
-
- Participant
- Posts: 38
- Joined: Wed Oct 01, 2008 10:30 am
-
- Participant
- Posts: 72
- Joined: Wed Dec 12, 2007 2:29 am
The filter stage is probably not the best choice for this type of requirement. The "Filter" stage evaluates the expression at runtime for every input row. Because the Transform is compiled it will always be faster than a Filter stage.
Also, use of Filter stage should be limited to instances where the entire filter expression must be parameterized at runtime.
Also, use of Filter stage should be limited to instances where the entire filter expression must be parameterized at runtime.
Mike Hester
mhester@petra-ps.com
mhester@petra-ps.com
Thanks for your inputs.
Sorry i have posted the actual requirement here in this link below.
viewtopic.php?t=140904
Sorry i have posted the actual requirement here in this link below.
viewtopic.php?t=140904
-------------------------------------------
Kumar
Kumar