DSXchange

There is a source file and a look up file.
Now i need to process only those rows from the source whose key column values match with the lookup file column values. Only those few rows have to be populated in the target.

Im using source as SQL server stage, A seq file for look up and a SQL Server stage as target.

Do i need to use any transformer in between?

How to write the logic?

Thanks
aschand

You would use just a lookup stage (no transformer) and set the lookup failure property to drop. Please read the chapter on Lookup stage in the Parallel developer guide.