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
Is hadoop a etl tool?
What are dimensions?
Give the benefits of data integration suite?
What are snapshots?
give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.
what is session partitioning?
what is session partitioning?
How many types of transformations supported by sorted input?
Identifying the bottlenecks in various components of Informatica and resolving them.
Difference between flat files and relational sources?
What is meant by incremental load?
Which transformation we use to convert 'NA' to 'Not Available'
What is initial load and what is full load?
what is granularity in Data ware House?
What is a mapping, session, worklet, workflow, mapplet?