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
Define the various join types of joiner transformation?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
what is diff b/t sorter t/r and agg have the option sorter property...
What is aggregator transformation in informatica?
While migrating the data from one environment to another environment how would you manage the connections?
How can one identify whether mapping is correct or not without connecting session?
Which is the t/r that builts only single cache memory?
What are the components of the workflow manager?
What's the layout of parameter file (what does a parameter file contain?)?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What is the reusable transformation?
What are the main features of Oracle 8i with context to datawarehouse?
What can we do to improve the performance of informatica aggregator transformation?
What is a joiner transformation?