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 / 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 |
I'd like the load to be triggered by client. By placement of a file or somehow. How is it done in Informatica? I'm using version 7.1.4 This is so urgent - I really appreciate your help :-)
3 Answers Alcatel-Lucent, ECI Telecom,
How to extract the informatica rejected data?
How will u pas the data with out debugger?
What are the different types of olap? Give an example?
how can one come to know wether the records loak into the target if we use update strategy
How to improve the performance of Aggregate transformation?
Can we use the mapping parameters or variables created in one mapping into another mapping?
tell me the push down optimization
What aer the out put files that the informatica server creates during the session running?
explain about session partitions ?
What are the types of schemas we have in data warehouse and what are the difference between them?
how to connect two or more table with single source qualifier?