DSXchange

Hi Guys

I have noticed sql input reference in odbc stage.May i know what is the difference between user defined sql and sql reference input. i have noticed both of them in odbc stage. can anybody help me to know the difference. i am not able to find in documentation much.Thanks

There are two kinds of input link, stream (get next row) and reference (get row by key). One SQL statement relates to the former, the other to the latter and contains a WHERE clause that refers to the key column(s).