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
- 13218 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / keshava
Using SQL
SELECT 'vishnraju@gmail', INSTR('vishnraju@gmail', '@'),
SUBSTR('vishnraju@gmail', 1, INSTR('vishnraju@gmail', '@')-
1) FROM DUAL
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
How to Create a folder using pmrep command?
Describe expression transformation?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What are the components of the workflow manager?
Explain load alternative records / rows into multiple targets - informatica
What is joiner transformation?
what is unit testing?tell me proceedure
What are the different versions of informatica?
State the differences between sql override and lookup override?
What differs when we choose the sorted input for aggregator transformation?
4 yrs etl devloper roles and responsibilities?any body give solutions
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
