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
- 13003 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / priyank
PORT=INPUT("vishnraju@gmail.com,suresh@yahoo.com,krishna@hotmail.com"
VAR_EMAIL_1=SUBSTR(PORT,1,INSTR(PORT,',',1,1)-1)
VAR_EMAIL_2=SUBSTR(PORT,INSTR(PORT,',',1,1)+1,INSTR(PORT,',',1,2)-1)
VAR_EMAIL_3=SUBSTR(PORT,INSTR(PORT,',',1,2)+1)
VAR_NAME_1=SUBSTR(VAR_EMAIL_1,1,INSTR(VAR_EMAIL_1,'@',1)-1)
VAR_NAME_2=SUBSTR(VAR_EMAIL_2,1,INSTR(VAR_EMAIL_2,'@',1)-1)
VAR_NAME_3=SUBSTR(VAR_EMAIL_3,1,INSTR(VAR_EMAIL_3,'@',1)-1)
OUT_PORT=VAR_NAME_1||','||VAR_NAME_2||','||VAR_NAME_3
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to join three sources using joiner? Explain though mapping flow.
How do you change a non-reusable transformation to reusable transformation?
Explain what are the different types of transformation available in informatica.
design of staging area?
What is a surrogate key?
Please let me know how to make Data masking in informatica..
How do you use reject loader.
How to generate sequence numbers using expression transformation?
Mention some types of transformation?
What is the different lookup cache(s)?
How can we use mapping variables in informatica? Where do we use them?
What do you mean by blocking transformation?
What is the difference between a repository server and a powerhouse?
what is degenerated dimension?
How many types of sessions are there in informatica.please explain them?
