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
- 13258 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
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
What is the procedure for creating independent data marts from informatica 7.1?
What are the settings that you use to configure the joiner transformation?
How to do the error handling of if ur source is flatfiles?
What are the data movement modes in informatica?
What are the different clients of powercenter?
What does update strategy mean, and what are the different option of it?
What can we do to improve the performance of informatica aggregator transformation?
What is rank index in rank transformation?
What is a pre-defined event and user-defined event?
What are the components of the workflow manager?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
What is workflow? What are the components of workflow manager?
EXL informatica Questions
