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;

Define error Threshold?

1 Answers  

---

Why we select the table which has minimum number of records as Master table in joiner?

4 Answers   HG, UST,

---

What is IQD file?

1 Answers  

---

Can we have a Mapping without a Source Qualifier?

14 Answers   Deloitte,

---

WHAT IS THE DIFFERENCE BETWEEN .NET AND INFORMATICA?

1 Answers  

---

What is rank index in rank transformation?

0 Answers  

---

i have two coloumn emp_no sal 1 3000 2 3000 3 3000 4 4000 5 5000 6 2700 7 4500 i just need output by removing duplicate.my answer should be emp_no sal 1 3000 2 4000 3 5000 and so on.please tel me the transformation to use and if variable is used in expression then how can i give variable expression

3 Answers  

---

What is the difference between informatics 7x and 8x and what is latest version?

0 Answers  

---

What is meant by LDAP users?

0 Answers  

---

If there are more than one sessions running parallel in a worklet, which will be the last session ?

2 Answers  

---

Can we use the mapping parameters or variables created in one mapping into another mapping?

1 Answers   Informatica,

---

Diff b/w ShortCut and reusabel Object ?

4 Answers  

---