Range lookup droping values or not getting values from refer

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
moulicherukuri
Participant
Posts: 5
Joined: Sat Apr 26, 2008 1:00 pm

Range lookup droping values or not getting values from refer

Post by moulicherukuri »

/*ds version 8.7*/
/* reference : sequential file*/

The following my scenario

I'm getting ZIP5, ZIP4 from source(CASS output) need to implement range operation on reference file which has ZIP5, ZIP4_Low_Range and ZIP4_High_Range.
All the columns datatype is varchar

I'm implementing the following scenario in lookup condition:

Input.ZIP5 = Reference.ZIP5(Equality)

Range condition:
Input.ZIP4 >= ZIP4_Low_Range
AND
Input.ZIP4 <= ZIP4_High_Range

Even though there is values in reference It's dropping/not bringing the values from reference file.
I applied trim on both side values too.


Thanks in Advance
Post Reply