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 pmcmd command usage in informatica

1190

How to convert multiple rows to single row (multiple columns) in informatica

1429

What are mapplets?

1329

can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2579

Briefly define reusable transformation?

1184

State the differences between sql override and lookup override?

1287

what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

2417

generate date / time dimension in informatica

1164

What is status code in informatica?

1065

What is decode in informatica?

1256

What are the settings that you use to configure the joiner transformation?

1105

can we override a native sql query within informatica? How do we do it?

1186

Explain in detail scd type 2 through mapping.

1092

What do you mean incremental aggregation?

1131

difference between repository database and repository service?

1224