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
- 9382 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 the way to execute pl/sql script using informatica mapping?
What is union transformation in informatica?
What is an unconnected transformation?
What is Session and Batches?
update strategy transformation in informatica
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
How an expression transformation differs from aggregator transformation?
Explain about cumulative Sum or moving sum?
Briefly define a session task?
What is the meaning of decode in informatica?
How to generate sequence numbers using expression transformation?
What is an Integration service in Informatica?
Explain what transformation and how many are there in informatica?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
what are the deliverables?in your project?
