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

my source contain data like this eno ename phno 100 john 9989020508 101 ram 7246599999 i want to load the data into target is eno name phno 100 john (998)-9020-508 102 ram (724)-6599-999.

5 Answers   TCS,


what are challenges that you faced in testing? give solution to it?

1 Answers  


error reading data in flatfiles. Instead rading Ravi Teja its reading Ravi?Teja.How to handle this issue.

4 Answers  


Explain one complecated mapping?

3 Answers   Fidelity, Wipro,


What are the components of the workflow manager?

0 Answers  


HOW DO YOU PARFORM INCREMENTAL LAOD ?

7 Answers   SAIC,


How can we use mapping variables in informatica?

0 Answers  


How can i explain my project architecture in interview..? in Igate asked me tell me your project flow from source to target..?

1 Answers   Ameri Group, CGI, CTS, HCL, iGate, TCS, Wipro,


Explain about the concept of mapping parameters and variables ?

3 Answers   HCL, TCS,


i have one senario i have table with 2columns one for primary key another is a constant value(zero). i have to lookup the table and get the maximum primary key here i don't have any common column between source and lookup table(wt table i explained above)... table is (i am assuming he didn't give the table) column1 column2 5 0 2 0 8 0 6 0 3 0 12 0 7 0

2 Answers   TCS,


What is the meaning of up gradation of repository?

0 Answers  


There are 100 lines in a file. How to print line number 31-50 and 81-90 in unix with a single command.

2 Answers   L&T,


Categories