DSXchange

i am new to parallel extender.i have seen some parallel jobs recently and i found out that orchestrate.columnname is used in the where clause of the oracle database stage which is accessed by a lookup stage.i want to know what this orchestrate.columnname represents.is it the column name of the other link going to the lookup stage and for using orchestrate.columnname do we have to use any job parameter.

orchestrate.[column_name] is basically Orchestrate's method in passing on data values that are provided on the input link to this database stage. If you ever coded in PL/SQL, you should understand this concept immediately.