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
- 5818 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 |
whats difference between ls -ltr and ls -lrt?
What are the functionalities of link collector?
What are some prerequisites for datastage?
what is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs? interm of output in Merge Reject link and Look Up Reject link ?
What are the types of containers in datastage?
tell me abt Datastage trigger?
I have oracle enterpaise stage, oracle bulkloader stage, ODBC stage and I want to load data in to target, which of the above stages do I need to use and why?
on how many columns we can perform aggregation in the Aggregator stage?
if a column contains data like abc,aaa,xyz,pwe,xok,abc,xyz,abc,pwe,abc,pwe,xok,xyz,xxx,abc, roy,pwe,aaa,xxx,xyz,roy,xok.... how to send the unique data to one source and remaining data to another source????
What are the repository tables in datastage?
how to load meta data
what is snow flack schema?
Teradata 
