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
- 13207 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / sunny
with data as
(
select 'vishnraju@gmail.com' coll from dual
union all
select 'suresh@yahoo.com' col from dual
union all
select 'krishna@hotmail.com' coll from dual
)
select SUBSTR(coll,1,(INSTR(coll,'@')-1)) AS USERNAME from data;
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
How to do the error handling of if ur source is flatfiles?
What is the difference between informatica 7.0 and 8.0?
Do you find any difficulty while working with flat files as source and target?
Explain dynamic target flat file name generation in informatica
What could be the possible resons of locks by user?
Differentiate between sessions and batches?
define galaxy repository in informatica
how many types of dimensions are available in informatica?
What is an aggregator transformation?
wat are deployement groups in informatica, how it will be used for developers
What are the limitations of joiner transformation?
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 the new features of Power Center 5.0?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
How do you promote a non-reusable transformation to reusable transformation?
