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
- 12218 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
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
what is song in infrmatica...?
What is powercenter on grid?
my source is junk data how will u remove that junk data by using unix please any one replay me
Clarify the aggregator change?
Explain the features of connected and unconnected lookup.
Design a mapping to load a target table with the following values from the above source?
What does “tail –f” command do and what is its use as an Informatica admin.
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What are active transformations.
How to go to the older version for a mapping?
How to configure mapping in informatica?
Please let me know how to make Data masking in informatica..
Under which circumstances, informatica server creates reject files?
