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
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
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
How union transformation is used?
What is a joiner transformation?
COM components can be used in Informatica
What is a surrogate key?
Explain dynamic target flat file name generation in informatica
How do you load unique records into one target table and duplicate records into a different target table?
What is decode in informatica?
What is deployment group?
What are the types of schemas we have in data warehouse and what are the difference between them?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What you know about transaction control transformation?
Can we change Dynamic to Static or Persistent cache? If so what happens?
How to update source definition?