Lookup FileSet question
Posted: Mon Oct 30, 2006 7:54 pm
My job has a dataset stage, DS1, as source, a lookup stage in the middle and a sequential file stage as target. The lookup stage is receiving an input link from a lookup file set stage. I also have an output reject link to a dataset stage. What I want to do is, if there is a match on Col1 of the incoming dataset with the reference link coming from the Lookup Fileset stage, I would like Col2 from the incoming Lookup Fileset stage to replace Col2 of the incoming dataset and send all columns to the target sequential file stage. This is not happening.
My lookup fileset stage was created by using a dataset file called DS2. The only difference between DS1 and DS2 is that DS2 has actual values of Col2 which will be used to update whereas DS1 has all dummy values in Col2.
Thanks.
My lookup fileset stage was created by using a dataset file called DS2. The only difference between DS1 and DS2 is that DS2 has actual values of Col2 which will be used to update whereas DS1 has all dummy values in Col2.
Thanks.