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
- 9126 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
Write the different tools in the workflow manager?
what is the hint? how to use it to reduce the query processing in program?
Whats the difference between informatica powercenter server, repositoryserver and repository?
Explain target update override in informatica
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
What are the main issues while working with flat files as source and as targets ?
Do you find any difficulty while working with flat files as source and target?
What is decode in static cache?
What is workflow? What are the components of workflow manager?
How can we use mapping variables in informatica? Where do we use them?
Explain the features of connected and unconnected lookup.
What is mapplet in informatica?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What do you understand by term role-playing dimension?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
