Hi All,
I have a job in which I have a DATE column which is NULL in source and NOT NULL in target. If my source value for date column is NULL, it don't want to reject that valule in trf stage.
I tried with couple of functions like IsNotNull or NullToEmptyu but not working.
Please provide if any funtion is available in Trf stage.
My job design is : Oradb-->Trf-->Oradb
I searched in forum, but couldn't find required solution.
Please help in resolving this issue.
Thanks in advance,
Function in Trf stage to drop nulls in Date column
Moderators: chulett, rschirm, roy
Hi Chulett, Thanks for your quick response.chulett wrote:First you have to decide what exactly it is you want in the DATE field when it is null in the source - some kind of in-band "null" value like 12/31/9999 perhaps? ...
I don't need that record which the Date field is having null value(or no value) in source, just want to discard it.
Ravi
Re: Function in Trf stage to drop nulls in Date column
You mentioned that you don't want to reject it and againravij wrote: If my source value for date column is NULL, it don't want to reject that valule in trf stage.
Assuming you want to discard it, you can use IsNotNull(DATE) in the Transformer as a Constraint.I don't need that record which the Date field is having null value(or no value) in source, just want to discard it.
Kris
Where's the "Any" key?-Homer Simpson
Where's the "Any" key?-Homer Simpson