Hi all,
I have a job design:
Sequential File --> transformer --> Oracle stage
I have a string field in format 'yyyymmdd'. I am to convert this string to Oracle date. The conversion is happening successfully using the function:
StringToDate(Column_Name,'%yyyy%mm%dd')
However, when I am using the code:
If Column_Name='00000000' Then '' Else StringToDate(Column_Name,'%yyyy%mm%dd')
I am getting warning: APT_CombinedOperatorController,3: Conversion error calling conversion routine date_from_ustring data may have been lost
Can anyone please tell me why am I getting this warning and its resolution.
Thanks in advance.
Warnings while converting String to Date
Moderators: chulett, rschirm, roy
You are passing '' (blank value) to date. You can either set it to Null or Pass a exterme values like '30/12/9999' etc.
Make the combinability to False in transformer properties. It will give you more debugging information.
Make the combinability to False in transformer properties. It will give you more debugging information.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'