DSXchange

what is the purpose of look up?
Can some one send me some examples for lookup?

Parent-child relationships between sets of data, the Lookup stage is documented in your manual.

kcbland wrote:Parent-child relationships between sets of data, the Lookup stage is documented in your manual.

can u elobrate ur explanation.

Thanks in advance.

If you are looking up for look up stage then please read the documentation. As a starter "The most common use for a lookup is to map short codes in the input data set onto expanded information from a lookup table which is then joined to the incoming data and output. " Also I see ure using server edition so please post it in the right forum.

Thanks,
Abhi.

Lookups in server jobs are achieved by painting one or more reference input links into a Transformer stage and supplying them from passive stage types that support "get by key" functionality (for example NOT Sequential File stage). You supply an expression in the Transformer stage that is used as the key value for the lookup operation.

A lookup returns the row that corresponds to the key value. If the servicing stage is an ODBC or a UV stage, it is possible to search on a non unique key and return more than one row. If the key is not found a row is returned in which every column is set to NULL. So a lookup in a server job behaves like a left outer join.

adams06 wrote:what is the purpose of look up?
Can some one send me some examples for lookup?

If you have a file that contains employee records with the employee State code alone...say FL, and you need the full state name, you can have a reference file with State Code and State Name...FL-->Florida and can lookup the first file against the reference file with the State code as key and get the State name in the output file w/ all other columns. Hope this helps