Answer / amedela chandra sekhar

S.D--->S.Q....>EXP T/R......>TGT


In exp t/r create one out put port give condition
by using Replace function we can achieve this scenario.

or sql query :

select replace('1:2;3','1:2;3','123') from dual;
ans:

REP
---
123

Answer / soujanya

select replace('1:2;3','1:2;3','123') from dual;

Answer / dbseeker

Im don't think Replace function would work ..
We have replacechr and replacestr functions instead.
try this ..

REPLACESTR(1,'1:2;3',':',';','')

should work fine.

Answer / dilip ingole

using sql same thing in informatica also

SELECT REGEXP_REPLACE('1:2;3.','[^[:digit:]]','') DATA FROM DUAL;

how to sort date field in infomatica?

2 Answers  

---

tell me the datawarehouse defination,and it is maintaing hystorical data meaning,what is the use

1 Answers  

---

Explain the shared cache and re-cache?

0 Answers  

---

If a workflow stops or fails after loading 10k records ? How can you recover it and If there is no order while reading data from source ?

2 Answers   IBM, WalMart,

---

what is the look up transformation?

2 Answers   Informatica,

---

what is the mechanism of the Master-Detail joining condition?

6 Answers   IBM, Patni,

---

what is the difference between Informatica7.1 & informatica 8.1

4 Answers  

---

How to load the name of the current processing flat file along with the data into the target using informatica mapping?

0 Answers   Informatica,

---

What are the different threads in DTM process?

2 Answers  

---

My i/p is like below 1,2,3,4,5,6,7,8,9,10....100 I want that to be populated in two o/p as below o/p-1: 10,20,30,40,50,60,70,90... o/p-2: 11,21,31,41,51,61,71,81,91.... How to do it in ingotmatica...

2 Answers   Accenture,

---

Is it passive or active when check and uncheck the box of DISTINCT in Sorter transformation? why?

6 Answers   iFlex, Morgan Stanley,

---

Is there any way to read the ms excel datas directly into informatica?

0 Answers  

---