error reading data in flatfiles. Instead rading Ravi Teja its reading Ravi?Teja.How to handle this issue.
Answers were Sorted based on User's Feedback
Answer / raghav
i feel that the format of tha file specified with in
informatica is wrong. What i mean in, say the format of the
file is UNICODE and that specifed in informatica is ASCII or
vise versa such problems may occur.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / gyana
Use a expression and use the REPLACE() fUNCTION TO REPLACE
ALL THE ? TO SPACE..BUT I DON'T UNDERSTAND Y IT READ LIKE
THAT..PLEASE CLARIFY ME IF U WILL GET ME
(gyana.informatica@gmail.com)
| Is This Answer Correct ? | 1 Yes | 0 No |
Use a expression and use the REPLACECHR ( ) fUNCTION TO REPLACE
ALL THE ? TO SPACE..Then only you will get the out put as Ravi Teja.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / gyana
Use a expression and use the REPLACE() fUNCTION TO REPLACE
ALL THE ? TO SPACE..BUT I DON'T UNDERSTAND Y IT READ LIKE
THAT..PLEASE CLARIFY ME IF U WILL GET ME
(gyana.informatica@gmail.com)
| Is This Answer Correct ? | 0 Yes | 1 No |
What is the procedure to load the fact table.Give in detail?
HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND LOOKUP?
one source to target loading insert new rows and update existing rows?
Explain the mapping variable usage example in informatica
In a scenario I have col1, col2, col3, under that 1,x,y, and 2,a,b and I want in this form col1, col2 and 1,x and 1,y and 2,a and 2,b, what is the procedure?
How to get rid of non ascii characters in a string? Ex:- United States Microsoft Visual Studio Tools for Applications 2012 x86 主控支援 - 繁體中文語言套件 to United States Microsoft Visual Studio Tools for Applications 2012 x86.
What is the advantage of persistent cache? When it should be used.
Issue with Update override at Target table in Informatica.
what is the difference between look up and joiner(don't say joiner sopport only = where as look up support non-equijoin).
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What are the different transaction levels available in transaction control transformation?
what is data modelling? what are types of modelling?In which suituation will use each one?