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



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

Answer / 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

More Informatica Interview Questions

I have a scenario with router transformation. but i dont want to capture records from default group. how can we achieve this.

3 Answers   Amdocs,


what is the difference between look up and joiner(don't say joiner sopport only = where as look up support non-equijoin).

3 Answers   IBM, ITC Infotech,


I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, i need to combine the other data and send it to a flat file. Distinct city names can be 4 or 5 or 6. So it has to dynamically generate flat files(4 or 5 or 6) corresponding to the city names.

2 Answers  


Which transformation can be created only as reusable transformation but not as non-reusable transformation?

1 Answers   Informatica,


What is reconstalation n What is fact constalation? Correct me if i m wrong in the question.

2 Answers   Mphasis,


where to store informatica rejected data? How to extract the informatica rejected data?

0 Answers  


What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

0 Answers   IBM,


what is datamart

4 Answers   IBM, Informatica,


Source is a flat file and want to load unique and duplicate records separately into two separate targets; right??

4 Answers  


How many mapplets u have created? and what is the logic used

5 Answers   Mind Tree,


empno sal 1 8000 2 9000 3 8000 4 1000 how to get highest sal wise rankings in rank t/r.

3 Answers  


What are the diffrences between joiner transformation and source qualifier transformation?

2 Answers  


Categories