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

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

1036


Different circumstance which drives informatica server to expel records?

918


what is index?how it can work in informatica

1982


What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

2310


Briefly define reusable transformation?

1077


How many dimensions are there in informatica?

1025


Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

1197


What does refresh system mean, and what are its distinctive choice?

1075


What are the designer tools for creating transformations?

1050


Can we change Dynamic to Static or Persistent cache? If so what happens?

2152


Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

1997


what is degenerated dimension?

3872


in reporting we add some new objects,how we get the count of the newly added objects to the report

2135


Explain in detail about scd type 1 through mapping.

1300


What are different types of transformations available in informatica?

938