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 is the meaning of decode in informatica?

1089

---

Explain sessions. Explain how batches are used to combine executions?

972

---

Explain the difference between a data warehouse and a data mart?

1024

---

What is a code page?

1129

---

Explain sessions?

1004

---

Explain informatica architecture - version 8 / 9

1046

---

can anyone explain me about retail domain project in informatica?

7902

---

Explain the use of aggregator cache file?

1205

---

What are session parameters ? How do you set them?

1793

---

What is the difference between writing a joiner query in ANSI style and THETA style?

2348

---

lookup transformation with screenshots

3961

---

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

1947

---

Can we create two repositories on same database instance in oracle?

1045

---

Why filter transformation is an active one?

942

---

Explain pushdown optimization $pushdownconfig parameter - informatica

1098

---