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
- 12217 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
What is a filter transformation and why it is an active one?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What are the differences between oltp and olap?
What are batches?
How do you remove duplicate records in informatica? And how many ways are there to do it?
Why update strategy and union transformations are active? Explain with examples.
Define update strategy?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Difference between Data and Index Caches?
How to update source definition?
How many ways a relational source definition can be updated and what are they?
Differentiate between Load Manager and DTM?
tell me about your project functionality
Explain sessions and how many types of sessions are there?
How we can use union transformation?
