Hello Everyone,
I am sorry to be asking about a SIGSEGV issue as I know the question has been asked many times because I used the search button. Unfortunately, I've not been able to find any help.
We are using DataStage 8.1. I am attempting to do a lookup using a range. The input file contains a number, an ID and two date columns (START and END date). The lookup file contains the number and ONE date. I would like to compare the number and START / END date from the input file to the number and a TRANSACTION date in the lookup file. I then want to pass through the corresponding ID from the source file.
All lookups are done using datasets. The datasets contain "not null" columns. I have no idea why this is not working, as it seems very basic to me and the SIGSEGV error is not helpful.
If anyone else has run into this before, please help! Thanks!
SIGSEGV Issue Using Lookup Stage for Range Lookup
Moderators: chulett, rschirm, roy
SIGSEGV Issue Using Lookup Stage for Range Lookup
"A minute of <B>anger</B> or <B>sadness</B> is <B>60 seconds</B> of <B>happiness wasted.</B>
-
- Participant
- Posts: 22
- Joined: Mon Aug 25, 2008 4:01 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
A Lookup stage needs to load the entire reference data set into memory. It would appear that you don't have enough memory for this. You need to re-think your design - perhaps load the reference data set into a database table and perform the BETWEEN join there.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.