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;

can anyone explain me about sales project in informatica?

8 Answers   MBT, Satyam,

---

when we use lookup,if have 5 records,if i dont need 1st and 2nd records..what will be the procedure to achieve by using lookup?/

5 Answers   L&T,

---

What are the circumstances that infromatica server results an unreciverable session?

1 Answers  

---

what is the command to get the list of files in a directory in unix?

5 Answers   iGate,

---

what is the difference between Informatica 7.1 and Abinitio?

1 Answers   TCS,

---

Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?

3 Answers   TCS,

---

What is log file,and where is it located,why u r using the log file

1 Answers   TCS,

---

How can u work with remote database in informatica?did you work directly by using remote connections?

2 Answers  

---

What is rank transform?

0 Answers  

---

What does role playing dimension mean?

0 Answers  

---

Have you worked with/created Parameter file

0 Answers  

---

What is diff joiner and lookup

4 Answers   BirlaSoft,

---