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
- 8983 Views
- Polaris, I also Faced
- E-Mail Answers
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
What is informatica? Why do we need it?
What is the scenario which compels informatica server to reject files?
What is meant by incremental aggregation?
Describe an informatica powercenter?
What is the procedure for creating independent data marts from informatica 7.1?
What are the differences between oltp and olap?
What is pmcmd command?
what are the Methods For Creating Reusable Transformations?
Explain incremental aggregation in informatica
How many ways a relational source definition can be updated and what are they?
where to store informatica rejected data?
Is it possible to create multiple domains on a single Informatica server?
What are the different transaction levels available in transaction control transformation?
How many dimensions are there in informatica?
What is a pre-defined event and user-defined event?
