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

Explain pushdown optimization $pushdownconfig parameter - informatica

1195

What are the tuning techniques you applied during your last project

2075

What is Index Caches size?

1164

explain abt ur project architecture?

2233

What are the types of lookup transformation?

1119

what is the size of u r source(like file or table)?

2307

How union transformation is used?

1057

What are ETL Tools?

1172

What is the use of source qualifier?

1185

Define filter transformation?

1148

Design a mapping to load the cumulative sum of salaries of employees into target table?

1556

Describe data concatenation?

1125

Explain about Informatica server process that how it works relates to mapping variables?

1128

What are the tasks that can be performed using sq?

1141

How can a transformation be made reusable?

1233