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
- 12208 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
Explain about Informatica server process that how it works relates to mapping variables?
How do you remove duplicate records in informatica? And how many ways are there to do it?
What are the new features of Power Center 5.0?
How do you load only null records into target?
Differentiate between a database and data warehouse?
What are the tasks that source qualifier perform?
Difference between Data and Index Caches?
What is the scenario which compels informatica server to reject files?
How to elaborate tracing level?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What is mapping debugger?
What is informatica powercenter repository?
What are the designer tools for creating transformations?
What is the meaning of up gradation of repository?
What is joiner change?
