Search found 1 match
- 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...