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
- 13426 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 IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What do you mean by worklet?
explan ur project architecture?
How can informatica be used for an organization?
Performance tuning in UNIX for informatica mappings?
Explain constraint based loading in informatica
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Can we create two repositories on same database instance in oracle?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Can we get 1st record through Informatica(without sequence number).
What are roles and groups and benefits of using them?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
Can we create multiple integration service on single repository?
How to elaborate powercenter integration service?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
