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 |
How to find from a source which has 10,000 records, find the average between 500th to 600th record?
what is mapping performence?
Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR How to do the above scenario in Informatica.
Can we insert and update a target table without using update strategy transformation?How?
Which transformation can be created only as reusable transformation but not as non-reusable transformation?
star and snowflake schema?
Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me
i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me
Hello...... How can i set my mapping as read-only? Please answer me. Advance thanks
When do we use dynamic cache and static cache in connected and unconnected lookup transformations?
There are 100 lines in a file. How to print line number 31-50 and 81-90 in unix with a single command.
In a concurrent batch if a session fails, can you start again from that session