How can we trouble shoot the commas in a column of a comma
delimited flat file in Informatica
Answer / 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 |
What is an expression transformation in informatica?
explan ur project architecture?
SOURECE Name id dept sal 1 a1 A 100 2 b1 B 200 3 c1 C 300 4 d1 D 400 TARGET: Name id dept sal 1 a1 A 100 2 b1 B 200 3 WER1 567 300 4 d1 D 400 I HAVE SOURCE AND TARGET. HOW TO VALIDATE DATA? TELL ME 5 STEPS ABOVE TABLE?
which transformation uses cache?
where to store informatica rejected data?
What is the use of target designer?
How can we eliminate duplicate rows from flatfile,explain?
Explain sql transformation in script mode examples in informatica
How the facts will be loaded? explain
Explain what are the different versions of informatica?
what is the diff b/w target load plan and cbl?
Explain Dataware house architecture .how data flow from intial to end?