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...
Answers were Sorted based on User's Feedback
Answer / ankit
Do it in Unix shell script . Search through "grep" for value
between [0-9] [A-Z] & other criteria .If condition doesn't
satisfy.U can pass a parameter stating invalid.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / babu
Hi,
As per my knowledje,i find below method for u r query.
select * from tab where col1 between 'A' and 'Z' or col1
between 'a' and 'z' or col1 between '0' and '9'
please let me know,if u have any concerns.
Babu
Is This Answer Correct ? | 5 Yes | 8 No |
Explain scd type 3 through mapping.
Explain the different kinds of facts.
If one flat file contains n number of records., we have to load the records in target from 51 to 100.. how to use expressions in Informatica..?
How to fix the etl bugs..Tell me the process?
why we are using surogate key in real time give me explanation
write asql query to filter improper date format? date 20-apr 11-mar-2010 30-may-2010 feb-2009 i want the output date 11-mar-2010 30-may-2010
Tell me one complex query in oracle ?
Define Pmrep command?
What is the session task and command task?
How i can upload the MainFrame source For Informatica ?
what are the limitation of sorter transformation?
What is complex mapping?