Page 1 of 1

Cascading Lookups

Posted: Mon Mar 12, 2007 8:36 pm
by sdfasih
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.

Posted: Tue Mar 13, 2007 6:32 am
by DSguru2B
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.

Posted: Tue Mar 13, 2007 6:34 am
by kumar_s
sdfasih - Atlast this post is also updated. Hence you cannot delete this as well. :wink:

Posted: Tue Mar 13, 2007 6:35 am
by DSguru2B
:oops: I did not realize this post was not to be answered to.

Posted: Tue Mar 13, 2007 6:37 am
by kumar_s
DSguru2B wrote::oops: 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.

Posted: Tue Mar 13, 2007 7:28 am
by DSguru2B
The job type was marked as server and hence I went ahead with it. O well.

Moderator: Please delete this post.