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
6665 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 is the Difference between Change capture stage and Difference Stage ? What are its significance individually ?

1 Answers

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

0 Answers

What are the unit test cases you used in your project?

1 Answers CSC, HY,

I have a few records just I want to store data in to targets cycling way how?

0 Answers Polaris,

What is the use of Row generator stage?

2 Answers

Can you explain repository tables in datastage?

0 Answers

what is the difference between INROWNUM AND OUTROWNUM IN DATASTAGE SERVER EDITION?

2 Answers

for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

0 Answers

Why we use parameters instead of hard code in datastage.

2 Answers IBM,

source file contains 100 records, i want 10 records in target file how it possible in datastage

6 Answers IBM,

What is the difference between operational data stage (ods) and data warehouse?

0 Answers

What is the function in Transformer stage can act as Rank Function in oracle

1 Answers Reliance,

For more Data Stage Interview Questions Click Here