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 extract sap data using informatica?
What is difference between a connected look up and unconnected look up?
How can informatica be used for an organization?
How the informatica server increases the session performance through partitioning the source?
What are different types of transformations available in informatica?
Three date formats are there . How to change these three into One format without using expression transformation ?
in my lookup table i want to catch the recently updated records from the source to target,how to achieve this and what is last commit interval point for this?
Enlist the differences between database and data warehouse.
what are the enhancements made to Informatica 7.1.1 version when compared to 6.2.2 version?
How many number of sessions that u can create in a batch?
Can we use parameters of parameter file in presession command
ONE FLAT FILE IS THERE WHICH IS COMMA DALAMETED . HOW TO CHANGE THAT COMMA DELEMITER TO ANY OTHER AT THE TIME OF RUNNING ?