You are not logged in.
How did you perform the "between" join with tMap? I'm facing the same need and am not sure how to use tMap for it, let alone another method.
I am developing a process in which I have to perform a Join between Table A and Table B where a value from A has to be in a range of values stored in B.
In SQL something like this
inner join b on a.column between b.range_start and b.range_end
I am forced to use a tMap component and I reckon this is not the way to go.
I could have easily used a tMap ELT but I am using pgSql and I don't have that component available (TOS 3.2.2).
I could use filtering condition, unfortunately this would mean generating a cartesian join: not feasable because the resulting dataset would be ~1000 rows from a cartesian of several millions.
Is there any other way?
The last chance would be to use an input component with an explicit join in the query but... not very clean.