Questions Ab Initio

  Scan with null key ---11 rec   Rollup with null key –1 record( depends if the data is sorted then last if data is not sorted then fst record)   Dedup with null key —( keep fst )—1 record   Dedup with null key —( keep lst )—1 record   Dedup with null key —( keep unique)—0 record ( key didn’t get the unique record bcoz it treats every record is one group      

  Ans :- Rollup     Key :id      

Input                     Output 1                           1 2                        12 3                        123 4                       1234 5                        12345       Scan   Out ::scan(in)=   Out .id :: concatenation(in.id);   Key :: null key