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 / kumaravelu
substr('TEST@COMPANY.COM',instr('TEST@COMPANY.COM','@')+1)
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
what is the difference between cubes and package in cognos
diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture
What is cube grouping?
how do u set partition points in the mapping?
Explain the difference between etl tool and olap tools?
What is full load & incremental or refresh load?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
List few etl bugs?
how do u identify the changed records in operational data?
when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?
How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?
Can u access a repository created in previous version of Informatica?
What is a mapping?
What are snapshots?
Explain about hash partitioning?