using sql same thing in informatica also SELECT REGEXP

I have source like this 1:2;3. so i want to load the target
as 123

Question Posted / dilip ingole

Answer Posted / dilip ingole

using sql same thing in informatica also

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

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain the types of transformations?

1068

What are the new features of informatica 9.x in developer level?

998

What is a pre-defined event and user-defined event?

1037

Differentiate between source qualifier and filter transformation?

1578

Why sorter is an active transformation?

1192

what is index?how it can work in informatica

2040

Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1979

What are the databases that informatica can connect to windows?

1052

How we can create indexes after completing the loan process?

1211

What is target designer and target load order?

1104

State the limitations where we cannot use joiner in the mapping pipeline?

1067

How can one identify whether mapping is correct or not without connecting session?

1451

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

2058

What is the function of union transformation?

1134

What do you mean by channel change?

1047