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 |
on a day i load 10 rows in my target and on nextday i get 10 more rows add to my target but out of 5 are update row how ican send them to target?how i can insert and update the records
two tables from two different databases r there . both having same structure but different data . how to compare these two tables ?
What are the data movement modes in informatcia?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Explain informatica architecture - version 8 / 9
how to remove staging area
what is index?how it can work in informatica
What are the types of schemas we have in data warehouse and what are the difference between them?
Enterprise data warehouse your projects phase by phase explain?
how will you remove the duplicate records from flat file without using sorter?
How to generate sequence numbers?
If I have a index defined on target table and if set it to bulk load will it work ?