DSXchange

Tony, This works well, provided you have well defined characters which can be part of the input string. How do you take care of different possible charcters which are in the input but you do not want in the output string? I mean, if I know my input string will only have have numbers, apha, #,$,% the...

Hi, You are having one source table(TBL A). Your job will have two outputs from a transformer. LinK A will have table with output UPDATE ACTION AS 'UPDATE EXISTING ROWS AND INSERT NEW ROWS' Link B will have INSERT ROWS WITHOUT CLEARING. (History Table) So Link A will have updated record. Link B will...

Hi You can write the records that failed (e.g. Oracle Errors) to a file or table by setting the Reject link Put the following statement in the Derivation for the Reject link. DSGetLogEntry(DSJ.ME, DSGetNewestLogId (DSJ.ME, DSJ.LOGWARNING)) [20] I tried it works. I am trying to figure out the way to ...