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
- 9021 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 |
Explain about the concept of mapping parameters and variables ?
What is enterprise data warehousing?
How to extract sap data using informatica? What is abap? What are idocs?
In warehouses how many schemas are there?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
why we use materialized view over view?
Q. WE ARE LOADING ORACLE TABLE THE PROCESS RUNS THREE HOURS. THIS TABLE IS BEING USED BY SOME DOWNSTREAM TEAMS SO WHAT WE WANT IS IN BETWEEN RUN IS PROGRESS IF ANYONE IS FETCHING THE DATA FROM THE TABLE THEY SHOULD SEE DATA TILL YESTERDAY TILL THAT. AFTER THAT PROCESS IS COMPLETED ONLY THEN TEAM SHULD BE AVAIBLE TO SEE TODAY DATA UPDATED. WE DONOT WANT TO LOG THE TABLE. NEED APROACH FROM YOUR SIDE.
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
Which gives the more performance when compare to fixed width and delimited file ? and why?
1)What is Data Masking in informatica? 2)How to restrict junk characters while loading data into target. 3) what happen if i won't pass sorted input in a transformation.
What is the difference between Bulk Load and Normal Load
If we have a two tables A & B A contain 10 records,B contain 20 records,what w'll b the o/p if we perform normal join,Master outer join,Detail outer join and Full Outer join how?
Teradata 
