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 |
What are differences between Informatica 7.1 and 6.1
What are batches?
what is galaxy repository?
What are the diffrences between joiner transformation and source qualifier transformation?
how may sources can be used in a mapping at a time?(limit)
Hi I'm new in Informatica. Can you show me a mapping sample on how to piviot the records? Thanks Robin
source table have 3 records? and it is sucessfully loaded into target. and 4more records is added in to source .that means 7 records now in source. we have to load the remaining 4 records into the same trgt table with maintian top 3 records. how ?can any one give me the data flow of this logic plz?
Can you copy the session to a different folder or repository?
how many types transformations supported by sortedinput?
What is a diff between joiner and lookup transformation
16 Answers CTS, Satyam, TCS, UHG,
what is incremantal aggregation?
my table contain duplicate Records i wanna load uniq records to my table . i have to pass the uniq records through filter t/r how?