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
- 8897 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 |
What are the tasks that can be performed using sq?
I want skip first 5 rows to load in to target? what will be the logic at session level ??
what is the main advantage of unconnected lookup
How do you take back up of repository?
Enlist few areas or real-time situations where informatica is required.
What are the types of presistent cache in look up tr.
Using Expression transformation how to remove duplicate records from a relational source?
hi talents, how do u get sequece numbers with oracle sequence generator function in informatica.... i dont need to use sequence generator transformation..... how do u achieve this???
How many ways are there to create ports?
What are the ETL tools available in DWH?
There are n numbers of flatfile of exactly same format are placed in a folder .Can we load these flatfile's data one by one to a single relational table by a single session??
how can u generate sequence of values in which target has more than 2billion of records.(but with sequence generator u can generate upto 2 biliion only)
Teradata 
