DSXchange

Hi Ray,

These 2 records are coming in the middle and as I dont have column names in file, i set below propery as false.

Hi,
I'm using Len(input) function in transformer constraint

Hi, My file has records of length 100 bytes and it is fixed width. I need to reject record if it does not have actul length. In transformer constraint, Im checking the length of the record. If it equals to 100, then sending to target, else sending to reject file. I have 2 records which is having len...

apart from primary columns,we have audit columns such as Create date, last update date

Hi experts, Need help on achieving restart procedure. My target table will get updated on hourly basis. approx. 17 times perday. if my job gets abort in middle of running, I want to delete all the records which are inserted on this particular load and rerun the job. that is, - it should not affect t...

Hi all, I need help on achieveing below logic. My file is having multiple header and detail & trailer. I'm having header file with sequence number. I need add that sequence number to its corresponding detail & trailer untill i find the new header. I have given sample input and output below. ...