SQL for Reference Inputs

[Sunshine2323]

Hi,

In the ODBC stage if we select User Defined Query, we get two input boxes for the SQL Query tab
--SQL for Primary Inputs
--SQL for Reference Inputs

To test the two we made a simple job which looks up against the ODBC stage and wrote the Select SQL in the SQL for Reference Inputs and ran the job.
The job ran giving the desired output except that the View Databutton was not enabled.

Now we did the same this time writing the SQL in the SQL for Primary Inputs and got the same result as before except that the View Data button was enabled.

What is the significance of the SQL for Reference Inputs input box?
Is there any performance enhancement for the lookup if the SQL is written in the SQL for Reference Inputs input box?

Thank You,

[ArndW]

Sunshine,

when you use this stage with a dotted-line as a reference input to a transform stage the "reference input" logic will be used - it has a SELECT whilst the main input quite often does not. The greying out of the view data button is a function of filling out the Primary input box.

[ray.wurlod]

Arnd really means that a reference link has a WHERE clause (to specify which row(s) to be looked up) whereas a stream link may not have a WHERE clause (of course, it may, but a reference link must have one).