error reading data in flatfiles. Instead rading Ravi Teja its reading Ravi?Teja.

error reading data in flatfiles. Instead rading Ravi Teja its reading Ravi?Teja.How to handle this issue.

Question Posted / raviteja.chck

4 Answers
6960 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

error reading data in flatfiles. Instead rading Ravi Teja its reading Ravi?Teja.How to handle this i..

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

error reading data in flatfiles. Instead rading Ravi Teja its reading Ravi?Teja.How to handle this i..

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

error reading data in flatfiles. Instead rading Ravi Teja its reading Ravi?Teja.How to handle this i..

Answer / pradosh ranjan swain

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

error reading data in flatfiles. Instead rading Ravi Teja its reading Ravi?Teja.How to handle this i..

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

Post New Answer