How to read a csv file which has a comma separated data within double quotes
In real world, most of the csv file will have comma separated data field which will enclose in a double quotes. When you read such kind of file in Informatica BDM, that particular data field looks truncated since the comma within data will be treated like a delimiter.
To fix the Issue you need to Give the Text Qualifier as "Double Quotes" in the Advanced properties of the flat file object.
- Click on the Flat file Object
- Go to Advanced >> Column format: Delimited >>
- Select "Text Qualifier" as "Double Quotes"
