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
What the difference is between a database, a data warehouse and a data mart?
What are junk dimensions?
server hot-ws270 is connect to Repository B. What does it mean?
What is the maplet?
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 is meant by lookup transformation?
What is the use of transformation?
How to create a non-reusable instance of reusable transformations?
How do you use reject loader.
what is the size of u r source(like file or table)?
What is union transformation?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What is complex mapping?
How would you copy the content of one repository to another repository?
What is source qualifier transformation in informatica?