Wednesday, December 5, 2012

How to find the nth highest salary in file?


Job:
sequential file-->sortstage-->transformer stage--->targetsequentialfile
sort stage settings
Sal-desc 

 Transformer stage settings
constraint-@INROWNUM=n

 Both the sort stage and transformer must run in sequential mode.
Posted by at
Labels:

9 comments:

  1. BasheerDecember 6, 2012 at 4:49 AM

    I tried it but it doesn't work..... Please give correct solution. I appreciate your effort...

    ReplyDelete
  2. Vamsi KrishnaDecember 6, 2012 at 6:46 AM

    may i know what is the problem your are facing to resolve the issue?

    ReplyDelete
  3. BasheerDecember 6, 2012 at 7:26 AM

    When i give this "@INROWNUM=n" in transformer contraint. it shows error like "Error in constraint Variable 'n' not defined.

    ReplyDelete
  4. Vamsi KrishnaDecember 6, 2012 at 8:03 AM

    We should not use n and it should be replaced by some integer For ex: 2 if u want to find the 2 highest salary.

    ReplyDelete
  5. BasheerDecember 7, 2012 at 9:30 AM

    Thanks for helping me ji.... How can we find last record of the file?

    ReplyDelete
  6. Vamsi KrishnaDecember 13, 2012 at 8:10 AM

    sequentialfilestage-->tail-->sequentialfilestage

    execution Mode for tail stage is sequential and Number of rows (per partition)=1

    ReplyDelete
  7. BasheerDecember 22, 2012 at 5:25 AM

    Vamsi I did course in datastage. Could you help me find better job in datastage?

    ReplyDelete
  8. UnknownOctober 13, 2013 at 9:50 AM

    Thanks Vamsi

    ReplyDelete

Subscribe to: Post Comments (Atom)