AnsweredAssumed Answered

SQL Lookup in the Map

Question asked by venkatesh.rupanagudi080702 on Apr 25, 2017
Latest reply on Apr 25, 2017 by Srinivas Chandrakanth Vangari



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.