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
Answer Posted / datastage4you
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 |
Post New Answer View All Answers
Define project in datastage?
Define meta stage?
what is the custome stage in datastage? how can we impliment that one? plz tell me
Describe routines in datastage? Enlist various types of routines.
whom do you report?
how to add a new records into source?
client know skid info?
What is the precedence of stage variables,derivations, and constraints?
What are the different plug-ins stages used in your projects?
What is the purpose of pivot stage?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
Why do you need stage variables?
Which commands are used to import and export the datastage jobs?
What are the primary usages of datastage tool?
Enlist various types of routines in datastage.