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 |
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?
If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks
In how many ways we can create ports?
how to through logic of informatica using the push down optimization into oracle.
Define Incremental Aggregation?
What are the types of maping in Getting Started Wizard?
what is metadata?
What is the different lookup cache(s)?
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
If a session fails after loading of 10,000 records in to the target.How can you load the records from 10001?
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.
What is the status code?