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

On a day i load 10 rows in my target and on nextday i get 10 more rows to add in target. But out of 10 - 5 records are send them to target?how i can insert the remaining records

1 Answers  

---

if the session fails after 100 records agian we have to starts the session or we go for recovery session

2 Answers   TCS,

---

Which gives the more performance when compare to fixed width and delimited file ? and why?

3 Answers   HP,

---

SOURCE NAME SAL GANGA 30000 RAJU 20000 PAVAN 25000 TARGET NAME SAL MAXSAL GANGA 30000 30000 RAJU 20000 30000 PAVAN 25000 30000 in mapping level how to achive that

5 Answers   DELL,

---

Please create a mapping where I have source which has one column with name like Aman_Gupta Rakesh_Mehra Sachin_More I want the target field should contain the name in reverse order i.e Gupta_Aman Mehra_Rakesh More_Sachin. Can you please tell me what transformation would be needed to do this.

5 Answers  

---

---

Which version configuration tool used in ur project?

0 Answers   CTS, TCS,

---

How to convert IBM Cognos generated XML to a readable XML format for ETL tools

1 Answers  

---

wat are deployement groups in informatica, how it will be used for developers

0 Answers  

---

What is the term PIPELINE in informatica ?

7 Answers   Deloitte,

---

What are the advantages of informatica?

0 Answers  

---

What are the challenges you have faced in your project?

1 Answers   Cognizant, Infosys,

---

What is version control in informatica ? Advance thanks

6 Answers   HCL, Puma,

---