Getting nulls after lookup stage even after key column match
Posted: Wed Jun 25, 2008 5:09 am
I have an Oracle stage with only one column ID(Decimal 15) and i am looking up on ID in another Oracle stage with 3 columns ID(decimal 15), DATE(decimal 15) and DW_ID(decimal 15). Then the data is loaded into the target table.
The lookup has no condition and the lookup failure condition is set to DROP.
The job runs successfully but i am getting NULL values for all records for the DATE column, while the values for ID and DW_ID column are correct.
I checked for 1 ID value in target table to that in the reference table and found that the corresponding DATE value is non null.
How can i fetch correct values for DATE column? What might be the problem?
The lookup has no condition and the lookup failure condition is set to DROP.
The job runs successfully but i am getting NULL values for all records for the DATE column, while the values for ID and DW_ID column are correct.
I checked for 1 ID value in target table to that in the reference table and found that the corresponding DATE value is non null.
How can i fetch correct values for DATE column? What might be the problem?