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

Does an informatica transformation support only aggregate expressions?

1024

Explain the code page compatibility?

1052

Clarify the aggregator change?

1014

What is the difference between informatica 7.0 and 8.0?

996

how to create user defined function (udf) in informatica

1290

What is dimensional table? Explain the different dimensions.

1159

What is intricate mapping?

1179

Is it possible to create multiple domains on a single Informatica server?

1220

How you prepared reports for OLAP?

1586

How we can create indexes after completing the load process?

1147

What is persistent lookup cache?

1017

What are the static cache and dynamic cache in informatica?

1173

Briefly describe lookup transformation?

1033

what is unit testing?tell me proceedure

2206

What are the types of lookup transformation?

1061