Cascading Lookups

sdfasih · Post by **sdfasih** » Mon Mar 12, 2007 8:36 pm

Hi,
I was wondering if there is a way to do this.I would like to know if I have three Hash Files each having a single column say Col1.
Hash1 Col1 is Source to transformer stage
Hash2 Col1 is lookup to transformer stage
Hash3 Col1 is lookup to transformer stage.
I can do a lookup Hash1 Col1 with Hash2 Col1.Now can I do a lookup Hash2 Col1 with Hash3 Col1?
Thanx in advance.

DSguru2B · Post by **DSguru2B** » Tue Mar 13, 2007 6:32 am

I think it is possible but you will see the key in red. I would rather do it in two transformers. Test it out and let us know.

kumar_s · Post by **kumar_s** » Tue Mar 13, 2007 6:34 am

sdfasih - Atlast this post is also updated. Hence you cannot delete this as well.

DSguru2B · Post by **DSguru2B** » Tue Mar 13, 2007 6:35 am

I did not realize this post was not to be answered to.

kumar_s · Post by **kumar_s** » Tue Mar 13, 2007 6:37 am

DSguru2B wrote: I did not realize this post was not to be answered to.

Its not your fault anyways.

There were many duplicate post created by OP, which was asked to delete.

DSguru2B · Post by **DSguru2B** » Tue Mar 13, 2007 7:28 am

The job type was marked as server and hence I went ahead with it. O well.

Moderator: Please delete this post.