Search found 2 matches
- Tue Feb 15, 2005 7:22 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Dates comparision between two dates problem
- Replies: 1
- Views: 1336
Dates comparision between two dates problem
Guys, How to compare date1( non key) from file1 to check in Between two dates i.e date2A and date2B ( both non keys) on file2. There is no common key between these two files to use hash file(server) or look up(PX). I can move this data to DB and use join there I completely lost performance and don't...
- Tue Feb 15, 2005 7:22 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Date between two dates - comparision
- Replies: 2
- Views: 2811
Date between two dates - comparision
Guys, How to compare date1( non key) from file1 to check in Between two dates i.e date2A and date2B ( both non keys) on file2. There is no common key between these two files to use hash file(server) or look up(PX). I can move this data to DB and use join there I completely lost performance and don't...