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
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
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.