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 / dbseeker

Im don't think Replace function would work ..
We have replacechr and replacestr functions instead.
try this ..

REPLACESTR(1,'1:2;3',':',';','')

should work fine.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the restrictions of union transformation?

1041


Describe an informatica powercenter?

1127


I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

2066


TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1866


How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1777


What's the layout of parameter file (what does a parameter file contain?)?

2385


what are factless facts? And in which scenario will you use such kinds of fact tables.

1808


What is meant by a domain?

1127


Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

1294


Whats there in global repository

1693


Explain the different kinds of facts.

981


tell me about your project functionality

2341


What is the procedure for creating independent data marts from informatica 7.1?

1066


What is Cognos script editor?

4230


What does update strategy mean, and what are the different option of it?

1091