DSXchange

hi ,

i have rw=equirement like this...

i got data from 2 tables fields like

table1

if lenth of value is one the multiply by 10

ex :1*10=10

table2 fields like
from to rating
5 10 1

11 20 2

21 30 3

suppose table1 value falls between any of table2 fields from and to corresponding rating value needs to be load into target.

ex :

if tbl1 value is 9 then rating should be 1(range between from and to)

please help

Please read your content before you post. It is not professional to expect others to decrypt your spec.

If you are planning for a range lookup, you can write your own SQL with between clause.

As mentioned, you wont need a Datastage to join get the result, as lot as both tables are in same database. Join the tables and get the result.

hi Kumar,

Thanks for your response.

The tables are not same database.