DSXchange

Hi,

Can we have multiple reference look ups where lookup1 result can be used in look up2 in the same transformer?


i.e result of look up1 is the key for lookup2

Thanks,

No, you will need to use 2 transformers to do this.

If I design the job that way and manually type in the column name in Lookup2, job compiles and even runs fine without aborting, was just curious if this was a bug in DS.

Thanks

No, not a 'bug' per se, more of a limitation of the GUI. This has been debated here in the past, some people will happily do what you did and others won't. In any case, it does work - at least up through through the 7.5.x version, but can't say if it will keep on working in future versions.

I have noticed the same thing. Designer does not seem to like this( I always get an angry red font) but the code does work.

Must be something to do with the fact that the Transformer already has evaluated the all columns for Lookup1 and has the corresponding data from the reference data source before it starts evaluating Lookup2.

Its better to stick with stuff that does not show up in red. As Craig notes, it might not work in future versions.