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
- 6663 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 the flow of loading data into fact & dimensional tables?
What are the some differences between 7.x and 8.x version of datastage?
Can you define merge?
What is ibm datastage flow designer?
why do u need the IOS upgradation in a FC switch
What is the roundrobin collector?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
root tree will find which is server job and which is parallel job?
What are the features of datastage flow designer?
Which warehouse using in your datawarehouse
What are system variables and sequencers in datastage
Describe stream connector?
What are the steps required to kill the job in Datastage?
Explain entity, attribute and relationship in datastage?
How to clean the datastage repository?
