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
- 13250 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 do you understand by SOA of Informatica?
What is the status code in stored procedure transformation?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
Can we change Dynamic to Static or Persistent cache? If so what happens?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
Define pmcmd command?
What do you understand by term role-playing dimension?
What is the difference between source qualifier transformations source filter to filter transformation?
What is complex mapping?
Mention few advantages of router transformation over filter transformation.
Can you use flat files in Mapplets.
According to his methodology what all you need before you build a datawarehouse
What is informatica metadata and where is it stored?
Can we create a node as a gateway node and the same node can be assigned to a grid?
Why update strategy and union transformations are active?
