I have requirement to search the sub string in the reference data.I have to check the existence of substring in the lookup master table.If it is present then process the record otherwise reject.
For this i have created the "Sparse Lookup" job in which i have source and reference has ODBC Connector stage.
I made reference as "sparse" and written user defined sql as
Code: Select all
SELECT COL1 FROM DB2ADMIN.TEST WHERE ORCHESTRATE.COL1 = COL1
But when i changed this query to
Code: Select all
SELECT COL1 FROM DB2ADMIN.TEST WHERE ORCHESTRATE.COL1 like '%COL1%'
Then all rows are rejected.
Can anyone help me to resolve this issue.
Thanks
Prasoon