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
- 11345 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 are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is rank transformation in informatica
Whats the difference between informatica powercenter server, repositoryserver and repository?
How are the sources and targets definitions imported in informatica designer?
difference between informatica 8.1.1 and 8.6
What are the informatica performance improvement tips
can you please explain me pre session and post session options?
What is the different lookup cache(s)?
What is informatica etl tool?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What is the difference between STOP and ABORT options in Workflow Monitor?
how many types of dimensions are available in informatica?
What are the performance considerations when working with aggregator transformation?
What is an unconnected transformation?
