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
Under what conditions selecting sorted input in aggregator will still not boost session performance?
what is the size of your data warehousing?
How many transformations can be used in mapplets.
In informatica workflow manager, how many repositories can be created?
What is an expression transformation in informatica?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
How we can use union transformation?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
How to load the data from a flat file into the target where the source flat file name changes daily?
in reporting we add some new objects,how we get the count of the newly added objects to the report
What are roles and groups and benefits of using them?
What do mean by local and global repository?
What are the differences between source qualifier and joiner transformation?
What is the difference between a repository server and a powerhouse?