Warnings while converting String to Date

[sweety123]

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.

[kumar_s]

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.