I have table(Emp) with the columns Eid,Ename,Sal,month(sal),year(sal) and DOB (say 15th-Jan-1981). Design a job such that the output displays Ename,year(sal),tot(sal) and current age i.e. For Ex: 18 yrs

barak

• Nov 21st, 2014

Using Transformer Days Between and divided by 365 - we can check for year with 366 if that's a big deal .

Answer Question  Select Best Answer

Explain some scenarios where a sequential file stage runs in parallel?

Chandra

• Jan 22nd, 2015

If you have multiple files ,need to change Read method to FILE PATTERN ,Then its run parallel mode

Balu

• Nov 25th, 2014

Changing the "no.of readers per node" to more than one . you can read a sequential file in parallel mode

Answer Question  Select Best Answer