CODEWITHSUNDEEP
etloracle-data-integratordata-integration
halfwind22
halfwind22

Reputation: 371

Field Overflow when column values contain space

I have a simple mapping to read data from a DB table onto a CSV delimited file using ODI(11g/12c). Certain fields are having values with words separated by spaces, like "United States of America". When the data is generated in CSV,I see that "United" is in one column, "States" is in the next column and so on. In other words there is an overflow of data in spite of the delimiter being set to ",".

IKM: SQL to File Append.

How can we resolve this?

Upvotes: 0

Views: 172

Answers (0)

Related Questions