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
- 5835 Views
- Accenture, I also Faced
- E-Mail Answers
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
What is a quality stage in datastage tool?
Define project in datastage?
How to perform incremental load in datastage?
What are sequencers?
Differentiate between datastage and datastage tx?
What is orabulk stage?
Why do we use exception activity in Datastage?
What are the repository tables in datastage?
what is use of SDR function?
What all the types of jobs you developed?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
how to add a new records into source?
How one source columns or rows to be loaded in to two different tables?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
root tree will find which is server job and which is parallel job?
