Search found 16 matches
- Thu Dec 05, 2013 3:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: based on Date comparison fetch exact value
- Replies: 3
- Views: 1973
based on Date comparison fetch exact value
Hi Everyone, My source table Table1 contains columns WELLID,ORIG_REF, LOG_DATE Sample data: WELL_ID ORIG_REF LOG_DATE ------- -------- -------- 1 CALIB 11/19/2000 2 BRITAN 6/30/2006 3 CALGRY NULL 4 DENVAR 8/20/2009 5 ALBERTA NULL i have to fetch one column from reference table : R_TABLE, columns:[OR...