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 / sunil
Use the replace function in expression and replace',' as null
REPLACE(1,sal,',null)..
It should work
Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Explain pmcmd command usage in informatica
What could be the possible resons of locks by user?
How do you use reject loader.
What you know about transaction control transformation?
How to load last n records of file into target table - informatica
In informatics server which files are created during the session rums?
Explain the features of connected and unconnected lookup.
What is a joiner transformation and why it is an active one?
What are active transformations.
While migrating the data from one environment to another environment how would you manage the connections?
Target increases every day even though no new record was inserted
Define filter transformation?
What is joiner transformation?
Explain sessions. Explain how batches are used to combine executions?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks