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
- 13043 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 might you approve all mappings in the archive all the while?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
What are junk dimensions?
Mention some types of transformation?
According to his methodology what all you need before you build a datawarehouse
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is rank transformation?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
How to create Target definition for flat files?
Different circumstance which drives informatica server to expel records?
what is the size of your data warehousing?
Which means the first record should come as last record and last record should come as first record and load into the target file?
What is a transaction control transformation?
What are Dimensional table?
wat are deployement groups in informatica, how it will be used for developers
