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
Modify Stage Nested Specification
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 41
- Joined: Tue Jan 24, 2006 3:43 pm
- Location: United States
- Contact:
Modify Stage Nested Specification
Knowledge is Power
That is a downside of the modify operator in that it doesn't allow such nested functions.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: