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
- 12212 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
Explain the mapping variable usage example in informatica
How are indexes created after completing the load process?
What is the format of informatica objects in a repository?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What is meant by query override?
What do think which one is the better joiner or look up?
Which transformation should we use to normalise the COBOL and relational sources?
What is the need for an etl tool?
How might one distinguish in the case of mapping is right or not without associating session?
What is workflow? What are the components of the workflow manager?
What is the use of code page?
What is olap (on-line analytical processing?
Explain the code page compatibility?
server hot-ws270 is connect to Repository B. What does it mean?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
