Answer Posted / 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

What are the reusable transformations?

779

---

What is the difference between stop and abort in informatica

759

---

What is the benefit of session partitioning?

700

---

What are the differences between a connected lookup and unconnected lookup?

720

---

tell me 5 session failure in real time how can you solve that in your project?

1737

---

---

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5140

---

Performance tuning in UNIX for informatica mappings?

2246

---

What is rank transformation?

670

---

expain about the tune parameters?

2006

---

Explain sql transformation in script mode examples in informatica

683

---

How would you copy the content of one repository to another repository?

650

---

Can we create a node as a gateway node and the same node can be assigned to a grid?

726

---

 Informatica Checkpoints

2943

---

What is decode in static cache?

685

---

What is domain in terms of informatica?

644

---