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
- 9022 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
define galaxy repository in informatica
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
where to store informatica rejected data? How to extract the informatica rejected data?
What are the types of data warehouses?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
Does an informatica transformation support only aggregate expressions?
What are the different transaction levels available in transaction control transformation?
Which is the t/r that builts only single cache memory?
What do you mean by channel change?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
Explain the difference between mapping parameter and mapping variable?
What is the difference between writing a joiner query in ANSI style and THETA style?
generate date / time dimension in informatica
Explain pmcmd command usage in informatica
Explain the features of connected and unconnected lookup.
