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?
Answer Posted / hardik
We can simple concatenate 3rd and 4th Row i.e 1 and 000 and
put that concatenated output port in target.
Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
draw informatica architecture 8.6 ?
As union transformation gives UNION ALL output, how you will get the UNION output?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
Plz can any one say me how to get the informatica certification materials and dumps
Define pmcmd command?
can we override a native sql query within informatica? Where do we do it?
Design a mapping to load the cumulative sum of salaries of employees into target table?
How to do unit testing in informatica? How to load data in informatica ?
How many ways are there to create ports?
Describe data concatenation?
What is the difference between writing a joiner query in ANSI style and THETA style?
What is domain and gateway node?
Write the prerequisite tasks to achieve the session partition?
what is the difference between informatica6.1 and infomatica7.1