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...

111111111111ravi11111111kumar11111111111?
i want display ravi kumar using sql?

Answer Posted / murali

In expr_trns we can use---

REPLACECHR (
1, "111111111111ravi11111111kumar11111111111" , '1', NULL)


Thanks,
Murali Udayagiri

Is This Answer Correct ?    1 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

6580


What is the use of an aggregator cache file?

1245


How to start a workflow using pmcmd command?

1299


tell me 5 session failure in real time how can you solve that in your project?

2387


What is informatica powercenter repository?

1253


What does command task mean?

1212


COM components can be used in Informatica

2450


Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

1325


While importing the relational source definition from the database, what are the metadata of source that will be imported?

1311


How to Create a folder using pmrep command?

1217


How can you define user defied event?

1073


What is Index Caches size?

1160


What is joiner change?

1191


What does cheating measurement mean?

1104


How to update a particular record in target with out running whole workflow?

1622