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 / magnil
how would it be possible if value is other than ,000?
Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
design of staging area?
What is DR strategy for Informatica project?
What do you mean by channel change?
Performance tuning in UNIX for informatica mappings?
How do you load only null records into target?
without table how to come first record only in oracle?
What is the meaning of up gradation of repository?
tell me 5 session failure in real time how can you solve that in your project?
what is informatica metadata?
Which transformation is needed while using the Cobol sources as source definitions?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Different qualification between a related rotate toward the sky and isolates look upward?
What are the differences between source qualifier and joiner transformation?
What is a rank transform?
What are the components of the workflow manager?