Getting nulls after lookup stage even after key column match

[jaideepbakre]

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?

[patil.bnk]

As u said i think the Oracle stage with 3 colums is taken as lookup, thats why you r getting null values

[venki]

As u said i think the Oracle stage with 3 colums is taken as lookup, thats why you r getting null values

Apply proper partetion before take lookup and check once again another small question, the datatype of data field is DATE or TIMESTAMP, You posted this date field with datatype Decimal 15,
I think other than lookup fields are having null values.

[keshav0307]

set lookup failure condition to fail.
then you know lookup found or not found.
what type of lookup used normal of sparsed?
what type of partition used in main and reference link.?