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

Define the various join types of joiner transformation?

1039


Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1096


what is diff b/t sorter t/r and agg have the option sorter property...

2230


What is aggregator transformation in informatica?

1001


While migrating the data from one environment to another environment how would you manage the connections?

1128


How can one identify whether mapping is correct or not without connecting session?

1493


Which is the t/r that builts only single cache memory?

1236


What are the components of the workflow manager?

1179


What's the layout of parameter file (what does a parameter file contain?)?

2433


I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1687


what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

2369


What is the reusable transformation?

1099


What are the main features of Oracle 8i with context to datawarehouse?

2158


What can we do to improve the performance of informatica aggregator transformation?

1139


What is a joiner transformation?

1033