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

I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

0 Answers

What are the enhancements made in datastage 7.5 compare with 7.0?

0 Answers

CAN WE DO HALF PROJECT IN PARALLEL JOBS AND HALF PROJECT IN SERVER JOBS?

2 Answers Infosys,

source file having the data like aabbccc, i want target file result like a1a2b1b2c1c2c3.

2 Answers

how may datastage variables/parameters will be in trnsformer stage? 1 2 3 4 ?

1 Answers Wipro,

why dataset ?

2 Answers

hi i am madan, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer

1 Answers HCL,

i have a scenario in which i/p columns areID,salary with 1,1000 2,2000 and 3,3000 i need an extra column in the o/p named avg(salary)how can i get it?

4 Answers L&T,

how will u design file watch jobs?

2 Answers

Can aggregator and transformer stages use to sort the data? How ?

2 Answers

What is Cleanup Resources and when do you use it?

2 Answers

What is quality stage?

0 Answers

For more Data Stage Interview Questions Click Here