error reading data in flatfiles. Instead rading Ravi Teja its reading Ravi?Teja.How to handle this issue.
- 4 Answers
- 5709 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
Enterprise data warehouse your projects phase by phase explain?
What are active and passive transformations?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
have u done any performance tuning? how u ll do?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
What is target load order?
How can we use mapping variables in informatica? Where do we use them?
What do you mean by filter transformation?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
Whats there in global repository
Explain the mapping variable usage example in informatica
Do you find any difficulty while working with flat files as source and target?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
How to extract the informatica rejected data?
How can we use batches?
