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

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