1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

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


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

How do u set a default value to a column if the column value is NULL?

7 Answers   HP,

What is RCP?

2 Answers   TCS,

I have a file it contain 2 records like empname,company as Ram, Tcs and Ram, IBM. But i want empname, company1,company2 as Ram, TCS,IBM in the target. How?

6 Answers   Cap Gemini,

Difference between sequential file and data set?

0 Answers  

What is ds designer?

0 Answers  




What is Horizontal transformation, vertical transformation,diagonal transformation?

2 Answers   Cap Gemini,

I am having the 2 source files A and B and I want to get the output as, the data which is in file A and which doesn't in file B to a target 1 and which is in file B and which doesn't in file A to a target 2?

3 Answers  

WHAT ARE THE STAGES U WILL USE IN IMPLEMENTING SCD2/DATE FIELD

8 Answers   L&T,

How we can convert rows to columns in datastage?

4 Answers   IBM,

how do u convert date in 20-12-07 to dec-20-2007 or 20-dec- 2007 or 20-dec-07 in parallel

3 Answers   Wipro,

how many dimentions and fact tables used in your project and what are names of it?

3 Answers   Tech Mahindra,

What is usage analysis in datastage?

0 Answers  

For more Data Stage Interview Questions Click Here
Categories