Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

How can we trouble shoot the commas in a column of a comma
delimited flat file in Informatica

Answer Posted / pavana

HI

In file properties set the optional quotes to either single
or double quotes. It considers the data b/w two Quotes as
the data for a single column .However the columns must be
separated by comma

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is degenerated dimension?

3965


where to store informatica rejected data?

1080


which one is better performance wise joiner or look up

1073


wat are deployement groups in informatica, how it will be used for developers

1701


What do mean by local and global repository?

1201


can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10666


In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

2047


If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

1475


What are the steps involved in the migration from older version to newer version of Informatica Server?

2091


What is flashback table ? Advance thanks

1922


What is the reusable transformation?

1035


What is the Process to creating lookup transformation in informatica

1032


in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2220


What are the tasks that can be performed using sq?

1078


What is informatica etl tool?

987