111111111111ravi11111111kumar11111111111?
i want display ravi kumar using sql?
Answer Posted / murali
In expr_trns we can use---
REPLACECHR (
1, "111111111111ravi11111111kumar11111111111" , '1', NULL)
Thanks,
Murali Udayagiri
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What is the use of an aggregator cache file?
How to start a workflow using pmcmd command?
tell me 5 session failure in real time how can you solve that in your project?
What is informatica powercenter repository?
What does command task mean?
COM components can be used in Informatica
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
How to Create a folder using pmrep command?
How can you define user defied event?
What is Index Caches size?
What is joiner change?
What does cheating measurement mean?
How to update a particular record in target with out running whole workflow?