Answered Questions

  • Jan 03 2013
    05:26 AM
    44822
    37

    How to get top five rows in DataStage?
    • naveen.chinthala

    How to get top five rows in DataStage? I tried to use @INROWNUM,@OUTROWNUM system variables in transformer..but they are not giving unique sequential numbers for every row...please help! Thanks in advance!!

    ravisankar

    • Sep 24th, 2018

    Also you can get form sequential file (Read first row (5))

    lalit

    • Oct 9th, 2017

    If you want to use transformer only so you need to sort that data first....and after that you need to know how many no. of partitions you have in your transformer stage. Because @inrownum and @outrown...