Questions Ab Initio

  Single stage components process each record in a single step.Below are example of single stage component.  Filter by expression  Reformat  Dedup    Multi stage components process records in multiple stages allowing more complex operations like  initialisation,  finalization   Below are the example of the multi stage components    Normalize  Rollup  Scan  Scan with rollup etc.

  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      

 Solution: Redefine Format   record   string( 1) data;   end     FBE   data member [ vector "A","a","E","e","I"," i "," O","o","U","u " ]     Sort   Key –Data     Rollup     Key –Data     out : : rollup(in) =   begin     out. data : : in.data ;     out.cc : : count( in.data );   end;          

Which ever path is provided in layout option, will be used to crate intermediate files.