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
- 17252 Views
- I also Faced
- E-Mail Answers
Answer Posted / satish
select replace ('323-237-2323','-') from dual
select substr('test@company.com',6,11) from dual
| Is This Answer Correct ? | 3 Yes | 1 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?
How to delete data which is not in source table?
list and discuss two approaches for updation of target table in Informatica and how they are different.
how do u really know that paging to disk is happening while u are using a lookup transform?
Explain do we need an etl tool?
What do you understand by the term ‘transformation’?
Explain about round-robi?
What are the types of Data Warehouse applications?
explain the methodology of Data Warehousing?(Polaries)
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
What are the three tiers in etl?
What is Data Vault???
What is partitioning? Explain different types of partitioning?
Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .
Explain do we need an etl tool? When do we go for the tools in the market?
