Search found 1 match
- Mon Mar 02, 2009 3:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Lookup using a Order by clause
- Replies: 2
- Views: 796
Lookup using a Order by clause
In one of our jobs we are using TIME_DIMENSION lookup..We are using below query in TIME_DIMENSION oracle stage "SELECT TIME_DIM_KEY,MONTH_OF_YEAR,YEAR FROM time_dimension where year=2008 and MONTH_OF_YEAR=11 ORDER BY TIME_DIM_DATE" to get values of TIME_DIM_KEY,MONTH_OF_YEAR,YEAR.We need t...