select replace('1:2;3','1:2;3','123') from du

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

Question Posted / soujanya

Answer Posted / soujanya

select replace('1:2;3','1:2;3','123') from dual;

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is persistent lookup cache?

969

How to extract sap data using informatica? What is abap? What are idocs?

1092

In informatics server which files are created during the session rums?

1066

Informatica settings are available in which file?

941

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

984

4 yrs etl devloper roles and responsibilities?any body give solutions

2077

What is lookup change?

988

Briefly define a session task?

1057

What is the advantage of informatica?

1016

Explain sql transformation in script mode examples in informatica

1048

Can you use flat files in Mapplets.

2612

What are the basic requirements to join two sources in a source qualifier transformation using default join?

1035

What are the informatica performance improvement tips

1018

What are the different options available for update strategy?

939

how to load rows into fact table in data warehouse

1117