Hi,
I am facing runtime error while using range lookup as "Lookup_56,1: Operator terminated abnormally: received signal SIGSEGV [processmgr/rtpexecutil.C:199]".
My requirement is as below:
--> Main link has 4 columns(EMP_ID, EMP_NAME, START_DATE,END_DATE)
12, ABC, 2010-12-11, 2010-12-23
--> Reference lilnk has 3 columns(EMP_ID, EMP_DATE, PERIOD)
12, 2010-12-20, 6
here i am doing lookup on M.EMP_ID=R.EMP_ID and R.EMP_DATE between M.START_DATE and M.END_DATE..
doing range lookup on reference link and normal lookup on EMP_ID.
My output should be
EMP_ID, EMP_NAME, PERIOD
12, ABC, 6
when i run the job it is giving "Lookup_56,1: Operator terminated abnormally: received signal SIGSEGV [processmgr/rtpexecutil.C:199]" and in job designer it is showing as green(Successfull). No records are getting to output.
I have seen many posts and tried according to that, but no use...
Please help me out. Thanks in advance.
Regarding Range Lookup
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 152
- Joined: Mon Mar 07, 2011 6:16 am
Re: Regarding Range Lookup
Better use a join stage and then filter out with the date range condition.I think it will work fine
Soumya