what do you understand by @INROWNUM, @PARTIONNUM, @NUMPARTITION?

3 comments:

  1. @INROWNUM is a system variable,it tells how many records are coming to each node
    @outrownum is a system variable,it tells how many records are going from each node.
    @num partition tells these records are going to which node
    @partition num tells records coming from which partition

    ReplyDelete
  2. @TRUE and @FALSE are like sudo codes which can be used to validate or check the boolean values of a stage variable or macro.

    ReplyDelete