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

How to join three sources using joiner?

1084

Differentiate between a database and data warehouse?

1129

how we can load rejected record's at run time?(not through bad files)

2361

How many input parameters can exist in an unconnected lookup?

1534

can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3855

Please let me know how to make encryption and decryption with example?

1887

What is a passive transformation?

1083

Target increases every day even though no new record was inserted

1565

Separate from a database, an information bazaar, and an information stockroom?

1073

How to go to the older version for a mapping?

1071

Mention few power centre client applications with their basic purpose?

932

Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

1266

hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1989

what is $$$$?

2134

Explain transaction control transformation in informatica

1252