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"
Answer Posted / kuttu
select trim(replace('2-3-4','-',NULL)) from dual
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)
What are your responsibilities as an etl tester?
what is granularity in Data ware House?
What is abap? What are idocs?
Mention few test cases and explain them?
Can u access a repository created in previous version of Informatica?
how do u identify the changed records in operational data?
what is the difference steps for data modeling?
What are dimensions?
What is etl process? How many steps etl contains?
What is a mapping?
What are the etl testing operations includes?
Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance
what happens if the info.server doesn't find the session parameter in the parameter file?
what is different between sequential batch and concurrent batch and which is recommended and why?