Answer / rathnakumar

select replace('111111111111ravi11111111kumar11111111111','1','') from dual;

Answer / jvdwhinfo

You are absolutely right Rathnakumar.
But we can also get the output by writing the query as
follows:
select replace('11111111ravi111111kumar11111',1,null) from
dual;
Anymore suggestions please let me know guys.

Thanks.
James

Answer / murali

In expr_trns we can use---

REPLACECHR (
1, "111111111111ravi11111111kumar11111111111" , '1', NULL)


Thanks,
Murali Udayagiri

tell me 7.x and 8.x diferrencess(but not transformations)

1 Answers  

---

when will we go for unconnected lookup transformation in Informatica?

6 Answers   CTS, IBM,

---

Using Informatica Visio to generate mappings. I am getting error "Table Definition Not Found Exception Error" while importing the template.

1 Answers  

---

What are the types of maping in Getting Started Wizard?

1 Answers  

---

What are the conditions needed to improve the performance of informatica aggregator transformation?

0 Answers  

---

How to extract original records at one target & Duplicate records at one target? {with out using EXPRESION transformation and sequence generator transformation?}<-this is important

4 Answers   CTS,

---

How union transformation is used?

0 Answers  

---

What is the command used to run a batch?

0 Answers  

---

how to identify new and old values in source qualifier or any other transformations using informatica

2 Answers  

---

Clarify the utilization of aggregator cache record?

0 Answers  

---

Two workflows are running at same time first workflow is succeeded but second workflow is failed but there is no dependencies?

1 Answers   IBM,

---

how can we update without using update transformation. wt is push down operation in informatica. which lookup gives more tuning performance. if so why.

6 Answers   CTS, Symphony,

---