Interested to Buy Any Domain ? << Click Here >> for more details...
How to convert alpha Numeric values to alpha using functions?
- 1 Answers
- 2996 Views
- CTS, I also Faced
- E-Mail Answers
Answer / niraj pathak
Using convert function
Sv1=convert (0123456789,col1,"")
| Is This Answer Correct ? | 0 Yes | 0 No |
Can we use Round Robin for aggregator?is there any benefit underlying?
Hi, My source is oracle(eno,ename,sal,commision,...), my requirement is like this, if there is a null values in commission col i want to keep it as null,and for the remaining first two characters of the value in my target. Plz help me
Please explain me the difference between 3 types of slowly changing dimension in datawarehousing?
hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column" hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column" i have no idea, what should i do..please help :(
How to transfer file from one system to another system in UNIX?which command to be use?
what is main difference between change capture and change apply stages
CAN WE DECLARE DATASET SET WITH OTHER THAN .DS EXTENTION OR NOT IF YES WHAT IS THE DIFFERENCE U FIND?IF NOT WHY?
plz tell me some dimentional and fact table names in banking project?
whats difference between ls -ltr and ls -lrt?
What are stage variables, derivations and constants?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
In the source seq file have 2 columns, i.e input: col1,col2 1,1 2,rajesh 3,15000 4,2 5,suresh 6,16000 7,3 8,veeru 9,17000 I want in the output like: eno,ename,sal 1,rajesh,15000 2,suresh,16000 3,veeru,17000 any one answer this scenario
Teradata 
