Please need your help to fix the lookup issue.
The job design
Code: Select all
DataSet
|
v
ODBC connector -> Lookup -> DataSet
(SQL server)
The join/lookup key is primary.Field1= reference.col1.
Both the below output columns are of Varchar(100) not null fields. The properties in Lookup Stage, failure is set to continue.
DEPT_LAST_UPDT_DT
DEPT_LAST_UPDTD_BY
I have tried to apply transformer before lookup and have applied TRim function for both input and reference and also peak stage.
The ouput value is coming as Null.
The above values exist in both input and reference.
When I make the Lookup Failure To Reject, iam able to get the 2 values in the reject file.
Any ideas or replies would be great help.
Thanks,