Interested to Buy Any Domain ? << Click Here >> for more details...
I have a source as flat file and having data like
""TCS"MUMBAI" and i want output like TCS MUMBAI,the length
of the data in the rows is variable.how can you fix it?
- 5 Answers
- 13423 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / ramesh
replacechar(columnname,instr(columnname,'"',1,2),' ')
the instr function finds the position of the char i.e. " in the second occurence and 'replacechar' replaces it with null.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
explain one complex mapping with logic? sales project?
How to do unit testing in informatica? How to load data in informatica ?
What is decode in informatica?
Explain pushdown optimization $pushdownconfig parameter - informatica
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
What is the procedure for creating independent data marts from informatica 7.1?
What is deployment group?
What is the format of informatica objects in a repository?
How would you join a node to the already existing domain?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
Can informatica load heterogeneous targets from heterogeneous sources?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
Is stop and abort are same in informatica?
What are the various types of transformation?
What is session task and command task?
