For getting current age, simply do the calculation in transformer, or in SQ

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

Question Posted / datastage4you

1 Answers
6771 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

Please Help Members By Posting Answers For Below Questions

Define project in datastage?

1100

Define meta stage?

1207

what is the custome stage in datastage? how can we impliment that one? plz tell me

2369

Describe routines in datastage? Enlist various types of routines.

1016

whom do you report?

1935

how to add a new records into source?

2000

client know skid info?

2086

What is the precedence of stage variables,derivations, and constraints?

1086

What are the different plug-ins stages used in your projects?

1078

What is the purpose of pivot stage?

1170

hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals

1873

Why do you need stage variables?

1184

Which commands are used to import and export the datastage jobs?

1414

What are the primary usages of datastage tool?

1075

Enlist various types of routines in datastage.

1259