DSXchange

Hello Folks

In one of the jobs we have , we extract a Year from Database and compare that with all the rows (each row has a year column) .

Right now i use a CG , using Dummy keys i lookup the input from DB and append the year to all columns .

Then it is taken to a Transformer to do a comparison . Is there a easier way of accomplishing this

I think it all depends on what you're doing when the year matches.
You can use a lookup stage. You might be better off doing an outer join with the table(s).

Ande