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 / abhishek
REGEXP_LIKE(COL_NAME,'[[:alphanum:]]')
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How can we update a record in the target table without using update strategy?
What are junk dimensions?
While migrating the data from one environment to another environment how would you manage the connections?
what is $$$$?
What are the databases that informatica can connect to windows?
Can you use flat files in Mapplets.
How many dimensions are there in informatica?
draw informatica architecture 8.6 ?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
What are the features of complex mapping?
What is the way to execute pl/sql script using informatica mapping?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
How to load the data from a flat file into the target where the source flat file name changes daily?
What are the popular informatica products?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar