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
- 5849 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
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
Lookup constraints
How do you register plug-ins?
What is the difference between an operational datastage and a data warehouse?
Which algorithm you used for your hashfile?
What is the sortmerge collector?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
What are the partitioning techniques available in link partitioner?
what is 'reconsideration error' and how can i respond to this error and how to debug this
How do you schedule or monitoring the job?
What are the types of jobs we have in datastage?
What is process model?
Demonstrate experience in maintaining quality process standards?
What are the different common services in datastage?
How can you write parallel routines in datastage PX?
