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
- 12210 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / bhagyasri
REPLACE(REPLACE(REPLACE(email_address, "@gmail.com", ""), "@yahoo.com", ""), "@hotmail.com", "")
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How many ways a relational source definition can be updated and what are they?
Explain the pipeline partition with real time example?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
How to call shell scripts from informatica?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What is a repository? And how to add it in an informatica client?
How can repository reports be accessed without sql or other transformations?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What does command task mean?
what is the Default Source Option For Update Strategy Transformation?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
According to his methodology what all you need before you build a datawarehouse
Explain sessions and how many types of sessions are there?
