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
6766 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

How to reverse the string using SQL?

1525

Define ds designer?

1277

State the difference between an operational datastage and a data warehouse?

1131

How do y read Sequential file from job control?

15960

Explain how a source file is populated?

1364

AGGREGATOR default datatype

1460

How many types of sorting methods are available in datastage?

1073

Explain ibm infosphere information server and highlight its main features?

1091

What is the command line function to import and export the ds jobs?

1153

What is the difference between in process and inter process?

1146

Differentiate between operational datastage (ods) and data warehouse?

1178

Differentiate between hash file and sequential file?

1072

Difference between in process and inter process?

1234

Can you define merge?

1119

What are stage variables and constants?

1147