I have the following columns in the EMP table Empid,Empname,Sal,month(Sal),ye

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 / alekhya

1 Answers
6775 Views
Accenture, I also Faced
E-Mail Answers

I have the following columns in the EMP table Empid,Empname,Sal,month(Sal),year(Sal) and DOB(let ..

Answer / 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

More Data Stage Interview Questions

WHAT are unix quentios in datastage

2 Answers TCS,

how to find diff between 2 dates without using Icon... funtions?

1 Answers

Enlist various types of routines in datastage.

0 Answers

How to use Environment variable's in datastage?(use of process)

1 Answers CSC,

Please Tell me..,I need some Complex Jobs in datastage as per in interview?how to tell and how to explain?please send as well as posiible please

1 Answers Systime,

pls ,tell me good Training centre with Job Oppertunity for Data stage in chennai?

1 Answers

Hi guys, 7. how to get this output i/p col1,col2 101,a 102,b 103,c 104,d o/p col1,col2 101,d 102,c 103,b 104,a Thanks

2 Answers Cap Gemini, IBM,

What are the some differences between 7.x and 8.x version of datastage?

0 Answers

1)What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?

1 Answers Hexaware,

What is orabulk stage?

0 Answers

Can you highlight the main features of ibm infosphere information server?

0 Answers

how can we do null handling in sequential files

2 Answers Reliance,

For more Data Stage Interview Questions Click Here