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



How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars oth..

Answer / 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

More Informatica Interview Questions

Informatica settings are available in which file?

0 Answers   Informatica,


I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

0 Answers  


What is expression transformation?

0 Answers  


Hello all, In SOA architecture i.e 8.6 , What is mean by node exactly?

4 Answers  


what is the process of target load planing?

2 Answers   IBM,






tell me about your project functionality

0 Answers  


What is Cognos script editor?

0 Answers   Cognizant,


without using rank transformation how can we rank items by using some other transformations

2 Answers  


what is incremental data aggregation?

3 Answers   IBM,


How do you set a varible in incremental aggregation

0 Answers  


Differentiate between Load Manager and DTM?

0 Answers  


Hi, As shown below i have repositories under that some folder are there . Between these repositories and folder some thing is there.I want to know what is that? repositories repo1 repo2 repo3 IS_## IS_## IS_## Folder1 Folder2 Folder3 - - - Here i want to what IS_## represents ? Advance Thanks

1 Answers   IBM,


Categories