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
generate date / time dimension in informatica
Define mapplet?
How to do unit testing in informatica?
How to extract sap data using informatica? What is abap? What are idocs?
How to create Target definition for flat files?
what is the size of your data warehousing?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
How do you change a non-reusable transformation to reusable transformation?
What is rank transform?
How you can differentiate between connected lookup and unconnected lookup?
can u any challenge your project?
What is domain and gateway node?
list out all the transformations which use cache?