Non equi join in datastage

[baglasumit21]

Can any one tell me some logic to implement the non-equi join using datastage. The example is given below.

Table1
Student Marks
A 50
B 80
C 70
D 35
E 90
...

Table2

Lowerlimit UpperLimit Grade
0 35 D
36 59 C
60 74 B
75 100 A

my desired output is as below



Student Marks Grade
A 50 C
B 80 A
C 70 B
D 35 D
E 90 A

[sachin1]

Transform routine will definitlyhelp.

[ray.wurlod]

A 101-row hashed file lookup table mapping mark to grade would perform best. You could use an expression with three nested levels of If..Then..Else. You could create a routine that does the same thing.