Posts

S) How to read different dml file to a single file ?

Image
  use red ef ine format or use read_multi ple file    

S) Dedup Example

Image
  input : -   id   1   1   1   2   2   3     Output required   id   1   1   2     Id   3   Id   1   2   Note : - Use dedup keep fst and keep last with null key .            

S) How to take a count of vowel present in a string ?

Image
 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;