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)
would be correct. So that it signifies the second key column passed to the where clause of the table.?2
Kindly clarify it please