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
- 13259 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
What the difference is between a database, a data warehouse and a data mart?
How you prepared reports for OLAP?
How can we store previous session logs?
What are the designer tools for creating transformations?
What is rank transformation?
What is Session and Batches?
What are the transformations that are not supported in mapplet?
What is a shortcut and copy in Informatica and how two are different with each other?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
Explain the mapping variable usage example in informatica
How to generate sequence numbers?
What is data caches/ index caches?
What is decode in informatica?
Differentiate between router and filter transformation?
Which development components of informatica have the highest usage?
