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...
- 1 Answers
- 16394 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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
What is the benefit of partitioning a session?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What is decode in static cache?
Can you use flat files in Mapplets.
my source is junk data how will u remove that junk data by using unix please any one replay me
what is size of u r database?
Can we create a node as a gateway node and the same node can be assigned to a grid?
How are the sources and targets definitions imported in informatica designer?
Describe expression transformation?
What are roles and groups and benefits of using them?
Explain the code page compatibility?
What are the mapping parameters and mapping variables?
how to load rows into fact table in data warehouse
what is diff b/t sorter t/r and agg have the option sorter property...
What is the use of code page?
