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

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

Question Posted / hareesh.sikakolanu

1 Answers
6110 Views
I also Faced
E-Mail Answers

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

What is aggregate cache in aggregator transformation?

0 Answers Informatica,

How u use pdf file in informatica source?

2 Answers Ericsson, HP, IBM,

What is meta data and system catalog?

2 Answers

What are the different caches used in informatica?

3 Answers UST,

What is meant by lookup transformation? Explain the types of lookup transformation?

0 Answers

Tell me about Propagate functions in informatica

0 Answers

How can i maintain unique surrogate key if 2 seperate workflows from different repository run and insert/update the main table at the same time.

9 Answers Barclays,

Can any body tell about the (UTC) unit test cases with the examples in informatica.

4 Answers

What is informatica metadata and where is it stored?

0 Answers

what is metadata?

8 Answers Satyam,

i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table. can any tell me procedure.

2 Answers TCS,

What is a command that used to run a batch?

4 Answers

For more Informatica Interview Questions Click Here