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
- 6901 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 |
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
how can u handle null values in transformer stage.
Differentiate between Join, Merge and Lookup stage?
client know skid info?
how to add a new records into source?
How to reverse the string using unix?
How do you start developing a datastage project?
What is the difference between operational data stage (ods) and data warehouse?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
how to define satge variables in transformer stage
what is meant by port ? what is the use of port ? what are the different type of ports and its usage
How to use Environment variable's in datastage?(use of process)
Teradata 
