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 do you understand by SOA of Informatica?

989


Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1091


What do you mean by blocking transformation?

1040


What is primary and backup node?

1127


Differentiate between router and filter transformation?

1012


What are the various types of transformation?

1179


What is the sequence generator transformation in informatica?

1184


How do you load alternate records into different tables through mapping flow?

1869


What is DR strategy for Informatica project?

1186


Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

1085


How can we use mapping variables in informatica?

1063


explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

2158


What is difference between a gateway node and worker node?

1138


What do you mean incremental aggregation?

1076


How to load a Dimension ? and how to load a fact table?

1418