Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

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

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