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

Hi,

 

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.

 

Thanks,

Venkatesh 

Outcomes