Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Asterisk in Lookup Text Field

Status
Not open for further replies.
pbackstrom

pbackstrom

Programmer
Jun 19, 2003
37
US
My lookup (from an Oracle table) fails whenever the field that it's supposed to match begins with an asterisk. That is, key of *AB12J will not find *AB12J in the lookup, returning null. Anybody hear of this or know a setting to change? I can try chopping off the incoming * and do a substr in the lookup query, but was wondering if there was an esc or something to be done. Informatica 7.1.
 
Sort by date Sort by votes
Never Mind.

It was a Case Sensitivity problem. Case Sensitive is not checked in my lookup transform, but it was treating it as case sensitive anyway.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

yimitz
  • Locked
  • Question
InstRev function in SQL for HIR
Replies
0
Views
91
yimitz
yimitz
donafran
  • Locked
  • Question
Is it possible Reuse a Reference Link to a Lookup stage for multiple fields?
Replies
2
Views
123
donafran
donafran
donafran
  • Locked
  • Question
How to code a condition in Sequence Job ??
Replies
1
Views
148
donafran
donafran
sa0309
  • Locked
  • Question
Passing an Oracle SP error message to Informatica Email Task
Replies
0
Views
94
sa0309
sa0309
donafran
  • Locked
  • Question
Using Variables in a PARALLEL JOB ODBC Connector SQL statement
Replies
2
Views
257
donafran
donafran

Part and Inventory Search

Sponsor

Back
Top