DSXchange

I also faced the same issue and it was a duplicate issue.

Hi all, I am getting below mentioned warning. CDC_Order: When checking operator: On input data set 0: When binding input interface field "ord_id" to field "ord_id": Implicit conversion from source type "ustring[max=40]" to result type "string[max=40]": Convert...

Hi All, Thanks in advance. I am getting below mentioned waring ##W IIS-DSEE-TTER-00134 11:14:13(024) <TDENTR_InJnTarStg> File tera_cs.txt either does not exist or contains no values for ICU charset 'ISO_8859-1:1987'; Even i tried to find tera_cs.txt but failed. Please suggested some ideas.

Hi ArndW, I tried with approch that is working fine except the "-" value at 0 position is not working fine because other then these four i have to set default date 0001-01-01. but i set for yyyymmdd that is working having "-" at 0 position. but if date is coming as ddmmyyyy also ...

Hi nagarjuna, I tried with ur suggestion but date is coming in ddmmyyy will have same length 8 as case of yyyymmdd and showing some data trucation warning. Hi ray.wurlod, We can not use server's job component or develop because we do not have client permision I am restricated to parral job only. Tha...

Yes, Date format are limited to four and we can not use Sever Job.
Any thing else we can not develop Sever job, it will be big client escalation.

Hello All, Thanks in Advance In my source data i have distinct date formats as yyyy-mm-dd, yyyymmdd, dd-MON-yy and d-MON-yy. My source field is Varchar2(60). I want ETL to standardize all this it to yyyy-mm-dd format. If any other date format is found, pass it as default date(0001-01-01) Please prov...