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

In informatica workflow manager, how many repositories can be created?

0 Answers  

---

can session assigned multiple mappings or not?

2 Answers   Zensar,

---

In Datastage, we have row generator stage to generate dummy row. Is there any such transformation in Informatica. Thanks in advance, Kumar

1 Answers  

---

How to join three sources using joiner? Explain though mapping flow.

0 Answers  

---

How to load the data from people soft hrm to people soft erm using informatica?

0 Answers  

---

---

Explain informatica architecture - version 8 / 9

0 Answers   Informatica,

---

can anyone explain me about sales project in informatica?

8 Answers   MBT, Satyam,

---

Hi all,Can any one provide me Informatica Designer Certification dumps.I need all three papers dumps.If any one has these dumps then plz send it on this id:- nagesh.jujjuru@yahoo.com Thanks in advance

1 Answers  

---

What differs when we choose the sorted input for aggregator transformation?

0 Answers  

---

How to recover the standalone session?

2 Answers  

---

Suppose i have 10000 records.First time i have to load 1 to 1000 records and second run i have load 1000 to 2000 records and third load i have to load 2000 to 3000 rows .How will achieve

15 Answers   TCS,

---

In Which scenario did u used Incremental loading?

2 Answers  

---