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 is degenerated dimension?
where to store informatica rejected data?
which one is better performance wise joiner or look up
wat are deployement groups in informatica, how it will be used for developers
What do mean by local and global repository?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What are the steps involved in the migration from older version to newer version of Informatica Server?
What is flashback table ? Advance thanks
What is the reusable transformation?
What is the Process to creating lookup transformation in informatica
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What are the tasks that can be performed using sq?
What is informatica etl tool?