lookup

krishna379 · Post by **krishna379** » Sun Sep 30, 2007 11:52 pm

hi
i want clearly give me information about the lookup

ray.wurlod · Post by **ray.wurlod** » Mon Oct 01, 2007 12:54 am

Welcome aboard.

The Lookup stage is one of many stages you can use in a parallel job. Its task is to retrieve zero or more rows from a data set that match supplied key value(s).

For more information read the chapter on the Lookup stage in the Parallel Job Developer's Guide

Attending an entry-level class on DataStage Enterprise Edition would help, too.

mcs@rajesh · Post by **mcs@rajesh** » Wed Oct 03, 2007 11:54 pm

hi pal, well lookup is a stage which reflects all the updates or changes in the master table in to the target...

mcs_giri · Post by **mcs_giri** » Sun Oct 07, 2007 12:32 am

hai krish,lookup will reflect the changes in the target by the source so that if the row is existing one then it is updated and it is new one then should be inserted.

ray.wurlod · Post by **ray.wurlod** » Sun Oct 07, 2007 2:57 am

The previous two posts are woefully inadequate, in that they only refer to one of the tasks that can be performed using a Lookup stage.