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
- 13241 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 can we handle two sessions in informatica?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What is a sorter transformation?
What is joiner transformation in informatica?
What is meant by a domain?
Explain the different dimensions.
Name the different lookup cache(s)?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is standalone command task?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
Please let me know how to make encryption and decryption with example?
What are the differences between joiner transformation and source qualifier transformation?
hi real timers . iam waiting for ur reply regarding ETL TESTING
How many ways are there to do 'remove duplicate records in informatica'?
What are junk dimensions?
