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
- 7633 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 lookup change?
What is workflow? What are the components of workflow manager?
How do we call shell scripts from informatica?
How can repository reports be accessed without sql or other transformations?
What is the difference between STOP and ABORT options in Workflow Monitor?
Explain how to import oracle sequence into informatica?
What is the different lookup cache(s)?
update strategy transformation in informatica
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
What are the different types of transformation available in informatica.
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
How do you manage the Parameter files while migrating your data from one environment to another environment?
How can we improve session performance in aggregator transformation?
What are the different transaction levels available in transaction control transformation?
How might you approve all mappings in the archive all the while?
