DSXchange

My problem is that the DATE variable is comming from a previous transformer and I don't see a way to pass it to my user-defined SQL for the lookup.

Any suggestions?

-Ashish

I need to fetch from a Hash file based on an expression other than the equi condition. I am trying to fetch based on DATE >Start_Date AND DATE <=End_Date, where Start_Date & End_Date are key columns from the HASH file and DATE is an input variable. I there an easy way to do this? I am trying to ...