1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / raviteja.chck

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

hw to load this give the mapping? cty state o/p c1 s1 c1 c1 s2 s1 c1 s1 c1 c2 s3 s2 c3 s4 c1 c3 s2 s1 c2 s3 c3 s4 c3 s2 2 columns should be loaded to one column in target table?

1 Answers   Wipro,

i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

1 Answers   CTS,

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

1 Answers  

how we can do session partition in informatica any one explain me clearly? thanks advance.

1 Answers   iGate,

how much memory (size) occupied by a session at runtime

4 Answers   Wipro,

Explain why we use partitioning the session in informatica?

1 Answers  

I want skip first 5 rows to load in to target? what will be the logic at session level ??

1 Answers   IBM,

What is synonym?

2 Answers   Patni,

How to load the source table into flat file target(with columns) in informatica?

4 Answers   Accenture,

What is meant by incremental aggregation?

1 Answers  

What is CDC? How to implement CDC?

4 Answers   People Tech, TCS,

Label in Informatica. How to remove existing Label.

1 Answers   IBM, Infosys,

For more Informatica Interview Questions Click Here
Categories