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
- 15590 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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
What is the advantage of informatica?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What is an Integration service in Informatica?
Explain how to import oracle sequence into informatica?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
Clarify the utilization of aggregator cache record?
can u give example for factless fact table
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
How to load last n records of file into target table - informatica
What are the components of the workflow manager?
What does cheating measurement mean?
How do you promote a non-reusable transformation to reusable transformation?
