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

I have a text file name x With a text message. Word informatica Is repeated for n number of times. How to count the number of occurrence Of word informatica Of word informatic in this file x.

1 Answers   Wipro,

---

What is informatica metadata and where is it stored?

0 Answers  

---

Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

0 Answers  

---

How to generate or load values in to the target table based on a column value using informatica etl tool.

0 Answers   Informatica,

---

Explain dynamic target flat file name generation in informatica

0 Answers   Informatica,

---

what r the propertes of workflow? and write quary to select dept more ten employess in dept.?

2 Answers  

---

source table have single column single record having with single space. load that source record into trg . trgt having two columns and the SOURCE TABLE LIKE COL1 BHANU PRASAD TRGT TABLE COL1 COL2 IN THAT LOAD THE RECORD IN THE trgt table LIKE COL1 COL2 BHANU PRASAD HOW ? TELL ME PLZ

2 Answers   Wipro,

---

How many number of sessions can one group in batches?

0 Answers  

---

How to do unit testing in informatica? How to load data in informatica ?

0 Answers  

---

Hi I'm new in Informatica. Can you show me a mapping sample on how to piviot the records? Thanks Robin

1 Answers  

---

my source is a comma delimited flatfile as eno, ename, sal 111,sri,ram,kumar,1000 and my target should be eno ename sal 111 sri ram kumar 1000 i.e; we need to eliminate the commas in between the data of a comma delimited file.

5 Answers   IBM,

---

list out all the transformations which use cache?

0 Answers   Informatica,

---