DSXchange

I have a source file in .csv format, and the delimiter for field is set to ',', but one of the column value has ',' as part of the value. This particular record failed. How should I fix? Example, the file name is company.csv. The delimiter is set to ','. The values are company id company name ======...

Datastage 8.1 i have a source table as the following ID # of email email ---- ----------- ------ 1 2 abc@abc.com, bcd@bcd.com 2 3 jfk@jfk.com, a2z@a2z.com, bbb@bbb.com I need to make each email address a record so the data in the target table will look like this ID email# email ---- --------- ------...