Result of tOracleInput

[Anonymous]

hi, i need to store the result returned by an sql query into a variable. Based on the value of the Variable further flow will be decided. How to do so? 

Current job flow is: 

TBufferInput >>> tFlowToIterate >>> tOracleInput >>> tJava

Query in tOracleInput = Select count(*) from EMP where EMP.id = somenumber

i want to get the result , and if result > 1 do something else something else.

Thanks in advance.

[manodwhb]

@tanvi_patil,since you can do in tMap.

[Anonymous]

thank you so much @manodwhb