Interested to Buy Any Domain ? << Click Here >> for more details...
in my source table one of column contains the data like
vishnraju@gmail.com,suresh@yahoo.com,krishna@hotmail.com these
records i need to send in target table as below format.
vishnuraju,suresh,krishna
- 5 Answers
- 13012 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / rayudu
HI ,
By using substr and instr we can retrive only the name part from the entire string and send to target.
Regrds,
rayudu
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
What is InformaticaPowerCenter?
Define enterprise data warehousing?
What is the way to execute pl/sql script using informatica mapping?
Explain sql transformation in script mode examples in informatica
What is sorter transformation?
Different qualification between a related rotate toward the sky and isolates look upward?
can we override a native sql query within informatica? How do we do it?
Which files are created during the session rums by informatics server?
How to join three sources using joiner? Explain though mapping flow.
Why update strategy and union transformations are active? Explain with examples.
What is rank transformation?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
Is there any way to read the ms excel datas directly into informatica?
What is olap (on-line analytical processing?
Explain direct and indirect flat file loading (source file type) - informatica
