I have a question on SQL lookup in Map.
For example : I use below SQL in the map .
Select Status from Table A where ID = Input-ID
The SQL Lookup requires Input and Output fields . How does the SQL resolve the Input and Output Variables ?. Does the Input variable supposed to be "Input-ID" and output Variable supposed to be "Status" for the SQL statement to resolve the Input and Output variables to execute successfully.