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
What are the main issues while working with flat files as source and as targets ?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
How will the document be delivered to me?
Mention a few design and development best practices for informatica?
What is main use of mapplet?
What is the difference between a repository server and a powerhouse?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is aggregate cache in aggregator transformation?
How to implement security measures using repository manager?
What all are steps in up gradation of Informatica server?
Informatica settings are available in which file?
What are the advantages of informatica?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
How to call shell scripts from informatica?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?