Interested to Buy Any Domain ? << Click Here >> for more details...
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...
- 3 Answers
- 8763 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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 |
In ur current projectu have done any performance tuning of mappings?
When the informatica server marks that a batch is failed?
what type of problem you faced insales project or insurance project
performance wise which one is better in joiner and lookup transformation?why?explain clearly?
What are the different types of code pages available in informatica & how to implement it in your project?
What is rank transform?
What is meant by active and passive transformation?
How are parameters defined in informatica?
How to write a procedure for a date which is in three different formats,and you want to load into datawarehouse in any single date formate
what are testing in a mapping level please give brif eplanation
What is the use of an aggregator cache file?
Hi, This is Lakshmi,Anyone taking classes for datawarehouse-Informatica and BO with real time project
Teradata 
