DSXchange

You dont need to change delimiter. Specify colon as your delimiter. In the transformer have a constraint

this problem is not resolved can any one help on this

iam getting the following error when i try to view data in the source sequential file, an i checked in the command prompt its working fine...

load_job__test..Sequential_File_0.DSLink3: ds_seqopen() - Error in filter command "tr -s '\n' ','" -
load_job__test..Sequential_File_0.DSLink3: ds_seqopen() - Error in execv() - No such file or directory



Thanks in advance

How do you expect the tr command to know which file to process? You have to tell it - it is not picked up from the filename property in the stage.

Thanks All i got to know that i missed to mention /usr/bin/tr -s '\n' ','
istead i placed just command tr -s '\n' ',' in filter command which is causing the above error.

ray.wurlod wrote:How do you expect the tr command to know which file to process? You have to tell it - it is not picked up from the filename property in the stage.

Actually, it is.

While you can certainly specify it in the filter itself (and sometimes need to depending on the specific syntax) it will combine your filename and filter command automagically. Not sure exactly what it does under the covers, seems to cat your file and pipe it to the filter from what I recall.

If you put the filename in the filter, I usually just put "/dev/null" as the value in the filename property.