Posts

T) How to mistakenly recover deleted object from EME

    air object rollback <rpath> version_number <eme-server-version-of-graph>    Please check help for more details.

S ) string_replace example

Image
      1A- id   1A- id   1|2| 3  replace to 1||2||3     Reformat     begin   Out.id : : String_replace (in.id ,”| ” ,”| |””);   End   Or   Reformat     begin   Out.id : : string_join ( string_split_no_empty (in.id ,”| ”) ,”| |”);   E nd   1B   In the 2 nd example input file1 to input7 contain one one letter like (1----7) if you are gathering all the input file using reformat and pass the  select condition next_in_sequence () <5 then what will  be the out put .   Ans --4      

S) scan ,rollup and dedup with null key and unique key

Image
  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      

S) join and rollup example

Image
 Input             Output 1 A                 1 ABC 2 B                  2 ABC 3 C                  3 ABC       Rollup :   out : : rollup(in) =     begin     out.id:: string_join (accumulation( in.data ), "" );   end ;   join   null key ( cartisian join)      

T) Difference between max core and max memory.

    Max core : component max-core parameter determines the maximum amount of memory the component will consume per partition before it spills to disk.   Max memory : Enables the collection of memory usage data for components.

S) Header trailer scenario using reformat & lookup

Image
          FBE   Next_in_sequence ==1;   Reformat   output_index_ out : : output_index (in) =   begin     output_index_ out : : if ( next_in_sequence () == lookup_count ( " hh " ) ) 1 else 0;   end ;