DSXchange

Hi, I have data coming in following format:- 1000, 1000,5 1000,52 where ',' denotes decimal... i want op in following format:- 0000000000000000100000 0000000000000000100050 0000000000000000100052 i.e THE SEPRATOR ',' should be removed and the amt field should be appended by zeroes(i.e if length befo...

thanx janhess

Hi.... i am again back with delimiters... what is the workaround if i have different delimiters to seprate fields within a record? for ex.:- i have data as:- CustomerID;ABCWIDGET~ABC Widgets, Inc. where my first delimiter is ';' between customerid and ABCWIDGET and second delimiter is ~ between ABCW...

Hi everyone....I am comparitively new to DSTX. My doubt is,how can i change the input delimiter of data in output file? for ex:- if my data is:- ABCWIDGET~A123~ABC Widgets (Delimiter ~) and i want ouput data as:- ABCWIDGET A123 ABC Widgets (Delimiter space) how can i achieve this using single type t...

right click on the canvass and click 'show performance statistics'

The other option is using execute command activity in sequence.

You can use before job/after job subroutine in job properties to call shell script.Scroll down to 'ExecSH' and input your command in 'input value'

One option can be changing properties on metadata page.To do this you can right click the concerned column,go to 'edit row',ther you can specify Actual field length, Null field length, and Null field value for that column.