Hi All,
I am extracting a timestamp attribute(EFF_DT(nullable), format as '2005-01-30 23:59:59') from oracle connector after join with another oracle connector and passing the value through a transformer and writing to a dataset.
I have handled null by using If IsNull(EFF_DT) or Trim(EFF_DT)='' Then '1900-01-01 23:59:59' Else linkname.EFF_DT.
But the records are getting dropped with the warning:
APT_CombinedOperatorController(1),0: Field 'EFF_DT' from input dataset '0' is NULL. Record dropped.
Kindly let me know how to handle the above problem.
Thanks in advance.
APT_CombinedOperatorController()
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 10
- Joined: Tue Jun 19, 2007 1:16 am
- Location: Bangalore
Place the IsNull() and Trim() calls in separate if expressions:
Regards,
Code: Select all
If IsNull(source) then default_value
else if Trim(soure)='' then default_value
else source
- james wiles
All generalizations are false, including this one - Mark Twain.
All generalizations are false, including this one - Mark Twain.
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
Hi,
Check if Eff_dt on the input link of join stage is nullable or not.if it is not nullable,please change it to nullable and run the job again.
Check if Eff_dt on the input link of join stage is nullable or not.if it is not nullable,please change it to nullable and run the job again.
Thanks
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/