Answered Questions

  • How do find out particular record in partition by using PBK?

    I have 400 records in my in0 file, its 4-way multifile system. How can I find out particular 150th record will goes to which partition using Partition by Key?

    Sjn

    • Nov 26th, 2020

    Hash_value(this_record,key)% no. of output partition = no of output partition for this record

    kumar

    • Oct 2nd, 2012

    Yes, exactly, we can find out by using hash formula.

  • Why go for sort within groups?

    We have sort and sort within groups components. we can achieve the sort within group functionality by placing two keys in sort group. Then why we have to go for sort within groups?

    Mahesh

    • May 26th, 2021

    One of the other examples could be :
    graph A has done PBKS on field A
    and when the output of graph A is being read by graph B it needs data to be sorted on fieldA and fieldB so major key is fieldA and minir key is fieldB.This saves time and increases performance.

    sundar

    • May 5th, 2015

    Hey Munmun,

    Do we need sorted data to sort with in group or component will taking care?

    Thanks