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

What are session parameters ? How do you set them?

1773


How can we handle two sessions in informatica?

982


What is a node in Informatica?

1002


Explain about Informatica server process that how it works relates to mapping variables?

1007


where to store informatica rejected data? How to extract the informatica rejected data?

955


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

1072


Clarify the aggregator change?

970


Define joiner transformation?

986


What is meant by pre and post session shell command?

1104


What is a joiner transformation?

938


Can anyone tell me the new features in Informatica 9 Version?

2032


update strategy transformation in informatica

1014


What is mapping debugger?

944


What are the steps involved in the migration from older version to newer version of Informatica Server?

2042


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?

1874