Records Dropped

[mspanda]

As u mentioned that your target is sequential file,

1. Go to "Format" tab.
2.Right click on "find Defaults".
You need to specify ADD SUBPROPERTY--->"Null field Value" to '0' then the records won't get dropped.


Regards
Prasanna Lakshmi

[sudhakar_viswa]

Hi SHIVARANJANI,

Here i have one more way to resolve this problem. That is Put the following condition for LAST_UPDATE_DATE column derivation in Transformer stage.

If IsNull(<<link_name>>.LAST_UPDATE_DATE) Then SetNull() Else <<link_name>>.LAST_UPDATE_DATE

Regards,
-- sudhakar