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 resilience time?

1220

What are the differences between source qualifier and joiner transformation?

1132

What is the fact table?

1130

What is meant by target load plan?

1026

What is the advantage of informatica?

1123

What is the sequence generator transformation in informatica?

1259

can you please explain me pre session and post session options?

7663

Explain sessions. Explain how batches are used to combine executions?

1075

Can you generate sequence numbers without using the sequence generator transformation?

1156

What are Dimensional table?

1116

What is the meaning of decode in informatica?

1163

How are indexes created after completing the load process?

1716

What are the static cache and dynamic cache in informatica?

1242

Define mapping and session?

1085

Explain lookup transformation is active in informatica

1145