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 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
Under what condition selecting sorted input in aggregator may fail the session?
How to do unit testing in informatica? How to load data in informatica ?
Explain dynamic target flat file name generation in informatica
In development project what is the process to follow for an etl developer from day1
Can we create multiple integration service on single repository?
Name the different lookup cache(s)?
What are the issues you have faced in your project? How did you overcome those issues?
explan ur project architecture?
what is degenerated dimension?
Design time, run time. If you don't create parameter what will happen
What is workflow? What are the components of the workflow manager?
What is the way to execute pl/sql script using informatica mapping?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
where to store informatica rejected data? How to extract the informatica rejected data?
In warehouses how many schemas are there?