Small clarfication :Embedding oracle code with Range lookup

[Ragunathan Gunasekaran]

Hi ,
I have two keys from the source and three keys in my Look up oracle table.
Key1 in the source table should be equal to Key 1 in the lookup table ...This is achievable just by mapping the two columns in the transformer and would be automatically passed to the Where clause of the Oracle stage.
But Key2 in the source should be between Key2 and Key3 in the lookup, I have achieved this by amending the SQL code as

Code: Select all

 WHERE ... AND (?2 <= Table_Name.Key2 and ?2>=Table_name.Key3)

Will this specification

?2

would be correct. So that it signifies the second key column passed to the where clause of the table.

Kindly clarify it please

[chulett]

No, it doesn't. In the OCI stage :2 would represent the second column, anywhere else the second ? in the 'where' clause would be mapped to the second Key column. Meaning, outside of the OCI stage with its numbered bind parameters, you'd need to pass the value in twice to achieve this. FYI.