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
- 14364 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?
Identifying the bottlenecks in various components of Informatica and resolving them.
Explain do we need an etl tool? When do we go for the tools in the market?
how do use session mapping parameters ?(in which transformation)
How to delete data which is not in source table?
what is dynamic insert?
what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?
list and discuss two approaches for updation of target table in Informatica and how they are different.
what are the concerns of OLTP and DSS systems?
What is a mapping?
What are materialized views & where do we use them?
Give the benefits of data integration suite?
what are the cubes developed in a sap bw project and what is the requirement for developing it?
how do u extract data from different data sources explain with an example?
what is the use of structures?how many nodes can u create in a structure?
