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
- 13002 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
Tell me about MD5 functions in informatica
What is confirmed fact in dataware housing?
pmscmd startworkflow -sv
What is a connected transformation?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
Where can we find the throughput option in informatica?
Explain what transformation and how many are there in informatica?
Which means the first record should come as last record and last record should come as first record and load into the target file?
How does a rank transform differ from aggregator transform functions max and min?
What are mapplets? How is it different from a Reusable Transformation?
What is decode in static cache?
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.
How to improve the performance of a session using sorter transformation?
what is the complex transformation you used in informatica
Explain scd type 3 through mapping.
