I searched about sparse lookup but did not find relevant information regarding my query.Hence posting it here :
I need to do a lookup of field ADDRESS_LINE_4 in one table on another field COUNTY of reference table (two diff. tables) and bring PROVINCE as a lookup result from reference table. The condition is i need to search in ADDRESS_LINE_4 (which contains entire address of a person) for a string which matches COUNTY value. For e.g. ADDRESS_LINE_4 contains value as 'DUBLIN 14' but COUNTY contains 'DUBLIN'. Note that ADDRESS_LINE_4 is coming from a dataset while COUNTY is coming from another table. I am trying to use sparse lookup for this.But since the two fields are coming from two different tables. The lookup is giving 0 output records.
How can this be performed ?
Sparse Lookup Query
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 221
- Joined: Fri Feb 17, 2006 3:38 am
- Location: India
- Contact:
Sparse Lookup Query
Thanks & Regards
Parag Saundattikar
Certified for Infosphere DataStage v8.0
Parag Saundattikar
Certified for Infosphere DataStage v8.0
-
- Participant
- Posts: 26
- Joined: Sun Dec 23, 2007 3:21 am
- Location: hyderabad
Re: Sparse Lookup Query
When we are having reference table contain more data than primary file, we will use sparse lookup. make sure before doing lookup trim the ADDRESS_LINE_4 field.
SRIKANTH