DSXchange

ray.wurlod wrote:Did you mean ORD_I = '0009000311_______________________ ' ? ...

yes.... exactly

Actually, the problem is with the field - ord_i char(40)

Since it is a CHAR field, database will append "spaces" to the data at the time of insertion.

Thus, the update SQL, should look for the value -

ORD_I = '0009000311 '
and not
ORD_I = '0009000311'

IF you can use a join and aggregator stage, then 1. Create a copy of input records in 2 streams. 2. on 1st stream, aggregate on event id to get the max value of transactions (MAX_TRANS) done. 3. join 2nd stream from step 1 with the results of step 2, to attach the MAX_TRANS for each event id. 4. Def...

I tried the option like StringToDate(MONTH : "/" DAY : "/" YEAR), "mmm/dd/yyyy"), but in vain your conversion function should be like - StringToDate(MONTH : "/" : DAY : "/" : YEAR), "mmm/dd/yyyy") ... also be cautious with the value of var...

Hi I am trying to configure the modify stage. The job execute with success, but with warning in log: Modify_12: When checking operator: When binding output schema variable "outRec": When binding output interface field "FXCRMCDPCC" to field "FXCRMCDPCC": Implicit conver...