Comparing a wild character in the source data with the lookup. All the time the lookup is failing and when i am trying to insert into the oracle db it is rejecting the record.
How to handle the wild characters in the datastage lookup stage .
Thanks
sri
Lookup for wild characters
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
That's because there is no mechanism in DataStage for "Comparing a wild character in the source data with the lookup". You will need to devise a more appropriate strategy.
Please post your source-to-target mapping specification for this column. This is an English language specification, not code or pseudo-code.
Please post your source-to-target mapping specification for this column. This is an English language specification, not code or pseudo-code.
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.