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
- 6847 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
how to implement scd2 in datastage 7.5 with lookup stage
Can you explain engine tier in information server?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
what are the errors,warnings in datastage
Describe the architecture of datastage?
What a datastage macro?
What is staging variable?
Can you explain tagbatch restructure operator?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
What are the functionalities of link partitioner?
How you Implemented SCD Type 1 & Type 2 in your project?
Define project in datastage?
What are the benefits of datastage?
what is 'reconsideration error' and how can i respond to this error and how to debug this
Define meta stage?
