Interested to Buy Any Domain ? << Click Here >> for more details...
CAN ANY ONE SEND ME THE CODE FOR THE BELOW
1).REMOVE '_' FROM TELE PHONE "323-237-2323" AND SHOULD
DISPLAY OUT PUT AS "323237232"
2). NEED TO ONLY "COMPANY.COM" FROM EMAIL
FILED "TEST@COMPANY.COM"
- 11 Answers
- 17003 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kumar
Use trim(columnname,'_','a') to remove the '-' values from
the columns
2) use field function: field(columnname,'@'2) to get the
company.com
Thanks
Kumar
| Is This Answer Correct ? | 2 Yes | 7 No |
What are the three tiers in etl?
HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com
Explain and compare etl & manual development?
When you have 2 servers in two different time zone and if you need to extract data from 1 server and load it in another server, how do you go about it? Best method to be used.
can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?
what are the facilities provided by OLAP to analytical users?
Explain about hash partitioning?
Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
What is the difference between project backlog and product backlog?
you have created a lookup transformation for a certain condition which if true returns multiple rows. when you go to the target and see only one row has come and not all. why is it so and how it can be corrected.
what is meant by drill through?(Mascot)
Teradata 
