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

How will restrict values in 0-9 and A-Z and a-z and special
character.Only allowed these chars otherwise we will reject
the records? what is the function we used to restrict...

Answer Posted / abhishek

REGEXP_LIKE(COL_NAME,'[[:alphanum:]]')

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can we update a record in the target table without using update strategy?

1150


What are junk dimensions?

1072


While migrating the data from one environment to another environment how would you manage the connections?

1090


what is $$$$?

2160


What are the databases that informatica can connect to windows?

1053


Can you use flat files in Mapplets.

2653


How many dimensions are there in informatica?

1091


draw informatica architecture 8.6 ?

3873


Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

7391


What are the features of complex mapping?

1161


What is the way to execute pl/sql script using informatica mapping?

1606


source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2722


How to load the data from a flat file into the target where the source flat file name changes daily?

1063


What are the popular informatica products?

1013


Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2747