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
- 13219 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
difference between informatica 8.1.1 and 8.6
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
what is the -ve test case in your project.
How to go to the older version for a mapping?
What is confirmed fact in dataware housing?
How will the document be delivered to me?
What does “tail –f” command do and what is its use as an Informatica admin.
Briefly define reusable transformation?
What is domain and gateway node?
list out all the transformations which use cache?
Explain dynamic target flat file name generation in informatica
What you know about transaction control transformation?
What is the meaning of up gradation of repository?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
How to convert multiple rows to single row (multiple columns) in informatica
