Answered Questions

  • Using Partition components

    i having 1000 records in in0 file. i want first 250 records into out0 file, next 250 (250 to 500)records into out1 file, next 250(500 to 750) records into out2 file, last 250(750 to 1000) records into out3 file using partition components?

    Prajna

    • Sep 3rd, 2013

    It can be done by Partition-by-round-robin giving the block-size=250

    shan

    • Oct 11th, 2012

    Partition by expression:next_by_sequence = 250

  • what is skew and skew measurement?

    Rajat Singh

    • Feb 20th, 2013

    Skew of a partition is the amount by which its size deviates from the average partition size

    vSudheer

    • Mar 3rd, 2012

    statistically, skew represent distribution of data.. when all partitions share equal amount of data, it is the best use of portioning. This can be achieved by partition-by-roundrobbin or by using equ...