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
Insert records of what lookup file has
Moderators: chulett, rschirm, roy
Re: Insert records of what lookup file has
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.
It took me fifteen years to discover I had no talent for ETL, but I couldn't give it up because by that time I was too famous.