Fast Load - Comma Problem within Field

Database
Enthusiast

Fast Load - Comma Problem within Field

Hi all,
Im having comma delimited flat file, one of the field(Address field - Varchar(30)) has some commas on it, Since there are commas, the address field is chopped and moved to the adjacent fields, Kindly advice how to resolve using Fastload.

Thanks in Advance,
Meem
1 REPLY
Enthusiast

Re: Fast Load - Comma Problem within Field

Normally for such situations... while generating flat file..., which work as source, the fields are covered under double quotes.
So Informatica help us in that case to take into account the other condition as well.
At present according to my knowledge, u cann't separate this field from others only on basis of comma.