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 is decode in informatica?

656


What is the fact table?

590


write a query to retrieve the latest records from the table sorted by version(scd)

631


Explain transaction control transformation in informatica

763


how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

1972






What is the difference between a repository server and a powerhouse?

811


what is size of u r database?

1850


Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

616


tell me the rules and responsblites in our project(my project is development)

1498


Differentiate between source qualifier and filter transformation?

1000


In which transformation you cannot drag ports into it?

780


What do you mean by blocking transformation?

585


Different circumstance which drives informatica server to expel records?

556


What is the surrogate key?

644


What are the measure objects?

662