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 do you understand by SOA of Informatica?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What do you mean by blocking transformation?
What is primary and backup node?
Differentiate between router and filter transformation?
What are the various types of transformation?
What is the sequence generator transformation in informatica?
How do you load alternate records into different tables through mapping flow?
What is DR strategy for Informatica project?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
How can we use mapping variables in informatica?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What is difference between a gateway node and worker node?
What do you mean incremental aggregation?
How to load a Dimension ? and how to load a fact table?