DSXchange

Hello,
I was wondering if there is a way to specify Null Handling and a type conversion together in a single Specification for Modify operators. If so can anyone share the syntax?

I have the following as the current specification:
CANCELLATION_DT=date_from_timestamp(CANCELLATION_DT)
I want to add the Handle_null specification to the result. How to do that?

The reason for doing this is that due to the Nulls the transformer in the successive part is dropping the records(at least I think that is the reason). And to do the CDC I have to get the timestamps in the same format or they would be flagged as updates for every run.

Any ideas are greatly appreciated.

Thanks,
Sreeram

That is a downside of the modify operator in that it doesn't allow such nested functions.

But you can use more than one Modify stage. You should explicitly or implicitly put a Copy stage between two adjacent Modify stages.