DSXchange

Have a Parallel Job to load the source data into a staging table. Source file has all fields comes in Varchar Format and during loading , i'm converting string to decimal for all decimal fields. If we have a numerical value then loading job completed successfully with no warnings. But if any one of ...

Thanks, Have changed the code like below still i'm getting the warning message. If len(Post_DT) = 8 then If IsValid('Date', Post_Dt[1,4]:Post_Dt[5,2]:Post_Dt[7,2]) = 1 then StringtoDate(Post_Dt, "%yyyy%mm%dd%) Else If IsValid('Time', Post_Dt[1,2]:":":Post_Dt[4,2]:":":Post_Dt...

Hi, I have a file with the below values in one of the date field: Field_Name : Post_DT 10:00:09 1111:11 14:54:37 09:08:07 20170812 The date column will have both time and date, if I get time then it has to be replaced with current_date while loading into target table and date will be as such, so hav...

Hi, The source file which i'm receiving has all fields in char format and target table has decimal field. so have used a transformer to convert StringtoDecimal, while doing so i'm getting an error as "expected precision not found" Input fieldname (EX_SN_REAL - VARCHAR(30)) Target fieldname...