Hi,
you can take source table and lookup table as source. After this add a exp transformation in each pipeline and create a dummy port in both exp trans, create sequence in both exp trans using sequence generator trans. After creating sequence take a joiner trans and in joiner trans put join condition like seq1=seq2. Now you have all column from source and lookup, pass desired column to the target.

Copyright 1998-2015 Ziff Davis, LLC (Toolbox.com). All rights reserved. All product names are trademarks of their respective companies. Toolbox.com is not
affiliated with or endorsed by any company listed at this site.