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

4 Answers
7551 Views
HP, I also Faced
E-Mail Answers

Answer Posted / soujanya

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

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Where can we find the throughput option in informatica?

1064

Why is sorter an active transformation?

1129

How can we store previous session logs?

1083

I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1628

What are the types of presistent cache in look up tr.

2055

What is decode in informatica?

1165

In how many ways we can create ports?

1123

difference between informatica 8.1.1 and 8.6

3677

Have you worked with/created Parameter file

1665

What are the differences between oltp and olap?

972

Performance tuning in UNIX for informatica mappings?

2568

Tell me about MD5 functions in informatica

929

What do you mean by enterprise data warehousing?

1065

Define filter transformation?

1099

How do you take back up of repository?

1162