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

Thanks to all people who are posting their comments...

1 Answers CTS,

Difference between sequential file and data set?

0 Answers

What are the repository tables in datastage?

0 Answers

input Name Salay Sam 10 Sam 30 Sam 20 Ram 40 Ram 50 Output should be Name Salary Count Sam 10 3 Ram 40 2 get min salary and count of name . OutPut 2 Name Seq Sam 1 Sam 2 Sam 3 Ram 1 Ram 2

1 Answers HCL,

how to configure databases through datastage

2 Answers

how to run jon in unix back round process what is command use in runing a job?

2 Answers HSBC,

Hi friends If anybody completed datastage 8.5 certification.Could please guide me what are the topics new in 8.5 certification.

2 Answers

What is the method of removing duplicates, without the remove duplicate stage?

0 Answers

How to create user defined environment varibale(parameter)?

1 Answers TCS,

im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination

0 Answers

Name the different sorting methods in datastage.

0 Answers

1.what is materialized data? 2.how to view the materialized data?

0 Answers HCL, IBM,

For more Data Stage Interview Questions Click Here