Oracle db

jiegao · Post by **jiegao** » Thu Nov 10, 2011 12:27 pm

What links are you mapping the output of the SQL query to?

India2000 · Post by **India2000** » Thu Nov 10, 2011 12:56 pm

oracle db is connected to lookup stage.I want to know the value of orachestrate here

jwiles · Post by **jwiles** » Thu Nov 10, 2011 1:51 pm

ORCHESTRATE in this context refers to the columns on your main input link: ORCHESTRATE:CUSTOMER is the CUSTOMER column from your input data.

Regards,

ray.wurlod · Post by **ray.wurlod** » Thu Nov 10, 2011 3:32 pm

ORCHESTRATE is an object (much like SQLCA is an object). In this case ORCHESTRATE has the same properties as your input link, so that you can refer to column names as properties of the object, for example ORCHESTRATE.CUSTOMER for the CUSTOMER column.