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
- 16975 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
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
What is Data Vault???
what is session partitioning?
SCD2 will work on only dimension tables as well as fact Table?
What are the differences between sql override and update override?
What are the different Lookup methods used in Informatica?
Explain etl?
Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?
what is the difference between cardinality and Nullability?
1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?
Explain about round-robi?
What is a lookup table in etl?
Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code
what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?
What are cubes and olap cubes?
