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
- 15595 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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 |
What is the difference between Oracle performance and Informatica Percfomance? Which performance is better?
What is the difference between Active and Passive transformation?
How many types of sessions are there in informatica.please explain them?
What is the default join that source qualifier provides?
surrogate keys usage in Oracle and Informatica?
5 Answers ITC Infotech, Oracle,
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@yahoo.co.in
Why is meant by direct and indirect loading options in sessions?
if we r using aggregator we enabled sorted input but the records r not sorted what happen?
What is update strategy transform?
in my source table i want to delete first and last records and load in between records into target? how can it possible?
3 Answers HCL, Thomson Reuters,
why normalizer transformation can not used in mapplet? plzzzz answer
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
Teradata 
