Hi all,
i need to perform a lookup with fields TABLE1.EMPLID CHAR(10) and TABLE2.EMPLID CHAR(11). which are data sources from DB2.
Both the fields have only numeric values.
I tried to typecast the two fields as INTEGER and equate them in the lookup stage, but the lookup fails.
Is there any other alternative,
kindly suggest the suitable alternatives.
Performing Lookup on Char datatypes with numeric values
Moderators: chulett, rschirm, roy
Performing Lookup on Char datatypes with numeric values
Thanks and regards
raman
raman
-
- Participant
- Posts: 467
- Joined: Tue Mar 20, 2007 6:36 am
- Location: Chennai
- Contact:
Do a trim and substring to take the first 10 characters of the column TABLE2.EMPLID and in datastage use varchar 10 or char 10 as the datatype for both the columns. If it fails, Please paste your warning or error here so that people can help you fix it :D
Minhajuddin
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>