Hi,
We have used sparse lookup in a job where the condition in the oracle stage is select value from table where lowsc<=orchestrate.sc and highsc>=orchestrate.sc.
So, i pass the field "value" to the output, based on the field sc from input .
Now, the job is failing with heap allocation error, and the ulimit is set to unlimited.
So, the only way is to change this condition to join.
Can anyone suggest, how we can do this in join, as this concept is conditional lookup.
Thanks!
sparse lookup-join
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You don't (have range lookup in version 7.5). Craig's not working on DataStage at the moment.
Join is only ever equijoin, so you won't achieve your requirement that way.
Would you consider using a server job, where you can use user-defined SQL in the database stage that services the reference input to a Transformer stage?
Join is only ever equijoin, so you won't achieve your requirement that way.
Would you consider using a server job, where you can use user-defined SQL in the database stage that services the reference input to a Transformer stage?
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.