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
- 9188 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
Have you worked with/created Parameter file
What are the components of workflow manager?
Explain the types of lookup transformation?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
What is union transformation in informatica?
in reporting we add some new objects,how we get the count of the newly added objects to the report
What is data transformation manager process?
What is workflow manager?
What is substr in informatica?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
draw informatica architecture 8.6 ?
What is a router transformation?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
