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
- 8735 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 |
if soource is having 10 records how will u insert 20 records to target
How to elaborate tracing level?
i have two tables,table 1 having 2 columns and 3 rows,table2 having 3 columns and 2 rows.what is the output if i do left outerjoin,full outer join,right outer join?
What is workflow? What are the components of workflow manager?
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@ayhoo.co.in
If you done any modifications for a table in back end does it reflect in informatca warehouse or maping?
Where can we find the throughput option in informatica?
Hi, In a mapping I have 3 targets and one fixed width file as source. Total 193 records are there . I connected one port in aggregator to all 3 targets. The same value need to be load into these 3 targets . It is loaded like that only but in different order. Why? The order of insertion should be same know for all 3 targets ? Then why the order is changed ? Any one please help me. Advance thanks.
Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to vanibv6@gmail.com Thnx Vani
How do you remove duplicate records in informatica? And how many ways are there to do it?
How many repositories can be created in informatica?
How can one know that a table has indexes and is partitioned? How data will be pulled from Partitions in Oracle for Informatica?
Teradata 
