Hi Everybody,
In one of my Load job (to Oracle)
I need to do lookup to find the key (from dimension table)
and load the target table with the key values
ie I am getting Account_Num as input and I need Account_Key for output.
Now if Account_Num does not exist, I do not want to reject my rows but continue the job with Default value for key.
ie
If Account_Num does not have respective Account_Key in the DB, I want to send -1 as Account_Key which stands for unkown in our DB.
I am using Lookup stage and Lookfilesets.
Please advice how this scenario should be handled.
Thanks,
Munish
Look up and SCD
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Make the "lookup failed" rule in your Lookup stage "Continue", and the fields derived from the reference input link Nullable. Downstream add a Modify or Transformer stage to handle the null, replacing it with -1.
You are still thinking like a server job developer. In parallel jobs the rule (mainly) is "one task, one stage". Or "one stage, one task". You can not substitute the in-band null within the Lookup stage. You need an extra stage.
You are still thinking like a server job developer. In parallel jobs the rule (mainly) is "one task, one stage". Or "one stage, one task". You can not substitute the in-band null within the Lookup stage. You need an extra 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.