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 / jey.dgl

Using RegMatch in Informatica to validate

IIF(reg_match(in_Email,'^[a-zA-Z][\w\.-]*[a-zA-Z0-9]@[a-zA-Z0-
9][\w\.-]*[a-zA-Z0-9]\.[a-zA-Z][a-zA-Z\.]*[a-zA-
Z]$'),'Valid','Invalid')

Is This Answer Correct ?    15 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Under what condition selecting sorted input in aggregator may fail the session?

1132


How to do unit testing in informatica? How to load data in informatica ?

1140


Explain dynamic target flat file name generation in informatica

1066


In development project what is the process to follow for an etl developer from day1

1728


Can we create multiple integration service on single repository?

1199


Name the different lookup cache(s)?

1241


What are the issues you have faced in your project? How did you overcome those issues?

2378


explan ur project architecture?

2076


what is degenerated dimension?

4012


Design time, run time. If you don't create parameter what will happen

1843


What is workflow? What are the components of the workflow manager?

1152


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

1622


If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

2016


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

1013


In warehouses how many schemas are there?

1086