DSXchange

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

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.