Hi All,
Im doing a Sparse lookup on a DB2 table.Its returing the lookup key values as Null eventhough the records in the reference table matches with that of Source table.But for the same Source and reference table,the lookup is working fine for SQL Server.
Please help me in this regard.
Thanks.
Sparse Lookup
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 42
- Joined: Wed Dec 26, 2007 1:58 am
- Location: India
Re: Sparse Lookup
If the key the with which you are doing the lookup is a char field,Pls do a trim by using LTRIM(RTRIM(column)) in the DB2 query,then carry the field as varchar from the DB2 stage.Subhasree wrote:Hi All,
Im doing a Sparse lookup on a DB2 table.Its returing the lookup key values as Null eventhough the records in the reference table matches with that of Source table.But for the same Source and reference table,the lookup is working fine for SQL Server.
Please help me in this regard.
Thanks.
Do the same for the reference also.(Propagate the column as varchar throughout,till the lookup)
Then go for a hit in the lookup,you will get a valid hit.
Regards