Search found 1 match

by teapczynski
Thu Apr 17, 2008 9:15 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem in joining 2 tables
Replies: 12
Views: 4040

Or do a lookup to the table2 for a dummy column with a value say '1'. You can check the lookup condition as give by you table1.a>table2.b and table1.a<=table2.c. In this case if there is a possibility of more than one record satisfying the condition, please do not forget to set the link name from w...