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
- 13220 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
What are the features of complex mapping?
How to load the data from people soft hrm to people soft erm using informatica?
lookup transformation with screenshots
What is Index Caches size?
What are the restrictions of union transformation?
Plz can any one say me how to get the informatica certification materials and dumps
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What are active transformations.
tell me about your project functionality
What are the settings that you use to configure the joiner transformation?
what is informatica metadata?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
How to load the data from a flat file into the target where the source flat file name changes daily?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
