Interested to Buy Any Domain ? << Click Here >> for more details...
source is a flat file
empname, empno, sal
ram, 101, 1,000
sam, 102, 2,000
ques: my target needs the data to be loaded as sal -1000 and
2000 excluding commas
target
empname, empno, sal
ram, 101, 1000
sam, 102, 2000
how to implement this?
- 5 Answers
- 8985 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / ramkrishna
open the original source flat file then from edit menu
select replace then enter values as find(,000) and replace
with (000)
then save the source file with other name then continue the
process as the flatfile
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Explain incremental aggregation in informatica
What is a code page?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
Explain scd type 3 through mapping.
Explain sql transformation in script mode examples in informatica
Clarify the aggregator change?
Which version configuration tool used in ur project?
What are the limitations of joiner transformation?
Why sorter is an active transformation?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What is a filter transformation and why it is an active one?
How to load last n records of file into target table - informatica
what are the deliverables?in your project?
tell me about your project functionality
