Interested to Buy Any Domain ? << Click Here >> for more details...
I have the following columns in the EMP table
Empid,Empname,Sal,month(Sal),year(Sal) and DOB(let us say the dob is 15th-Jan-1981)
Desing a job such that the output contains the following
empname,year(sal),tot(sal) and current age i.e. whether 18yrs or so on
- 1 Answers
- 6855 Views
- Accenture, I also Faced
- E-Mail Answers
For getting current age, simply do the calculation in transformer, or in SQL itself
http://goo.gl/atN4AT
www.datagenx.net
| Is This Answer Correct ? | 0 Yes | 0 No |
AGGREGATOR default datatype
What is difference between symmetric multiprocessing and massive parallel processing?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
wt is the difference between swith and filter stage
1.i have 5 jobs(1-5),i connect with each other,i want run from 3-5 only how? 2.how to schedual the job in datastage7.5 2? what is the deff bet grip and fgrep command? how do you cleanse the data in your project
What are the types of views in datastage director?
I have 2 Files like fileA fileB Output1 Output2 Output3 1 6 1 6 11 2 7 2 7 12 3 8 3 8 13 4 9 4 9 14 5 10 5 10 15 6 11 7 12 8 13 9 14 10 15 please let know
Difference between server jobs & parallel jobs?
What is a merge in datastage?
1.what is materialized data? 2.how to view the materialized data?
How complex jobs are implemented in datstage to improve performance?
how to unlock a locked job in datastage 8.0
Teradata 
