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
- 13245 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
How do you load first and last records into target table?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What is target designer and target load order?
What is an expression transformation?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What are the tasks that source qualifier perform?
How to convert multiple rows to single row (multiple columns) in informatica
can u give example for factless fact table
How to do the error handling of if ur source is flatfiles?
How to generate sequence numbers using expression transformation?
Where do we use mapping variables in informatica?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
Which version configuration tool used in ur project?
Can informatica load heterogeneous targets from heterogeneous sources?
How to handle decimal places while importing a flatfile into informatica?
