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
- 13037 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / rayudu
HI ,
By using substr and instr we can retrive only the name part from the entire string and send to target.
Regrds,
rayudu
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
What is different between the data warehouse and data mart?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
How do you manage the Parameter files while migrating your data from one environment to another environment?
What is an aggregator transformation?
What is workflow monitor?
Differentiate between source qualifier and filter transformation?
can we override a native sql query within informatica? Where do we do it?
Enlist the advantages of informatica.
What do you mean incremental aggregation?
Explain dynamic target flat file name generation in informatica
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,
Enterprise data warehouse your projects phase by phase explain?
what is informatica metadata?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
