range between values

muralik · Post by **muralik** » Thu Sep 24, 2009 8:22 am

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

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Sep 24, 2009 9:29 am

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.

kumar_s · Post by **kumar_s** » Thu Sep 24, 2009 9:45 pm

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.

seshikumar · Post by **seshikumar** » Wed Sep 30, 2009 6:33 am

hi Kumar,

Thanks for your response.

The tables are not same database.