Hi All,
I have one flat file with some name. I have data from some table. I need to join them using soundex function on name. How can I use Soundex function on joining keys?
soundex on joining keys
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 36
- Joined: Thu Dec 03, 2009 9:11 pm
- Location: Malaysia
Re: soundex on joining keys
Use the stage variable read it with soundex and compare it..
Not tested it though , it should work. Logically
Regards
Naveen
Not tested it though , it should work. Logically
Regards
Naveen
Naveen Kumar
Datastage Consultant
Datastage Consultant