DSXchange

did a sorting on both the fields emp_id and emp_date(secondary sort key)
then after use a remove duplicate stage (emp_id as a key column) to remove the duplicate.

Did not find any blog related to server job performance and in which condition to use server jobs.

what is the name of the site?

why use server job when we have parallel jobs which run much faster than server jobs?

Didi not find Sort stage in Datastage 7X server

Didi not find Sort stage in Datastage 7X server

The input sequential file contains same emp_id but can have different date. The output should have single row containing emp_id, sal , date which is latest. Looking at the example it should have output dataset as: EMP_ID EMP_SAL EMP_DATE 1 100 01/01/2010 2 300 01/01/2011 3 200 01/01/2009 4 100 01/01...

The out should contain Emp_id which contains latest date.
And what is head/tail commands?

Have a sequential file Columns: EMP_ID EMP_SAL EMP_DATE 1 100 01/01/2009 4 200 01/01/2005 2 300 01/01/2011 2 400 01/01/2009 1 100 01/01/2010 3 200 01/01/2009 4 100 01/01/2007 3 300 01/01/2006 . . . Output should contain the the emp_ID who has the latest date

Sorting data from sequential file.

Where do i get info about "PreviousRowCompare"?

Define Subroutine.

I am planning to apply SCD2 in server jobs. Can someone help me in the logic

Thank You kondeti.

Do you mean
SCurrent value needs to be assigned to SPrev.

I want to remove duplicate using stage variable.
For doing this I need to compare the current value of column with the previous value.
How do I maintain previous value in the stage variable?