How to load the top 3 marks(column name) from seqential file to the target

  • Interview Candidate
  • 2
  • 2291

Showing Answers 1 - 2 of 2 Answers

Sathish123

  • Feb 20th, 2007
 

First sort the data on Marks  column using sort stage then use transformer stage.
In constraints use system variable @INROWNUM (@INROWNUM<=3).
In this way you can get top 3 marks.

  Was this answer useful?  Yes

SudhirKanojia

  • Feb 8th, 2010
 

This can be achieve by sort & external filter satge.
First sort the data in descending order after that use external filter stage & give UNIX command  head -3 in the box.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions