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 |
How to fasten loading of 100 million distinct records in informatica? (Initially they are loaded into target without using any transformation, taking 2 hours)
Why is sorter an active transformation?
Is informatica power center designer has 64 bit support?
What is source qualifier transformation?
When to use normalization transformation other than cobol source?
Can you generate sequence numbers without using the sequence generator transformation?
if the session continuous run what can we do. means shall we stop the session or abort session. what is the correct reasion. why this situation occurs
1 2 3 * 4 5 6 * 7 8 9 how to load records between two stars(*),
How would you join a node to the already existing domain?
Source as 1 1 2 2 3 3 How to get target as 1 2 3 and 1 2 3
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What is mapplet in informatica?