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



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

More Informatica Interview Questions

In dept 10, 5 emp sal, i want to do sum of dept 10 emp sal. Is there any othere transformation than the aggrator? if yes how?

5 Answers   Patni,


If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks

7 Answers   Puma,


In how many ways we can create ports?

0 Answers  


how to through logic of informatica using the push down optimization into oracle.

2 Answers   Hexaware,


Define Incremental Aggregation?

2 Answers  






What are the types of maping in Getting Started Wizard?

1 Answers  


what is metadata?

6 Answers  


What is the different lookup cache(s)?

0 Answers  


my source contain data like this cno cname sal 100 rama@gmail.com 1000 200 karuna@yahoo.com 2000 i want load my data to the target is cno cname sal 100 rama 1000 200 karuna 2000 plz send the answer

5 Answers   IBM, TCS,


If a session fails after loading of 10,000 records in to the target.How can you load the records from 10001?

5 Answers   TCS,


i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2.

3 Answers   Wipro,


What is the status code?

1 Answers  


Categories