Abinitio Reformat - RunTime Behaviour

 Abinitio Reformat - Run Time Behavior


Watch my you tube channel for the explanation:





Steps:

Be mindful that each out port has corresponding error and reject port, the record will be redirected to these ports based on the action generated in the respective transform of the associated output port.


1. Reformat reads the record

2. if select is defined then , if select return True then record goes further else dropped out to be no where be caught , If select expression OR select transform results into NULL then graph does error out and stops execution

3.  if select is not defined then input records further processed

4.  now it turns to pass from transform function

  a. if output index or output indexes are not defined then record will be send to all output ports

b. if any of these functions defined then the record will be route from that respective port and send across to the respective out put port.

In case of both parameters defined( i.e. we have both output index and output indexes configured then

output indexes takes priority over output index.


5. if any error comes then the respective error and reject port can receive the error and rejected record due to the error, this depends on the configuration of Reject Threshold and Ramp. Limit.

   if selected Never abort , if reject and error port are connected to output then all rejected and error will be captured and component does not fail.

 if selected Never abort , if reject and error port are not connected to output then all rejected and error will be discarded and component does not fail.

if Abort on First Reject then the first error will result in graph abort.

if Ramp/Limit will be used then the graph will process depending on the percentage of the input records

and then it fails , if the entire processing is within the limit then it does not fail. we can capture the error and reject while connecting the ports.



Try to test while you have proper AbInitio licensed software. All above explanation is according to my work experience.


visit out peace and meditation YouTube channel:

paradisetracks


Comments

Post a Comment

Popular posts from this blog

Abinitio Interview Question # 1 - Write Multiple Files in Abinitio

Image
 Question :  I get records of various region in huge volume ,  we want to write the records in region specific files.   How to achieve that? View the explanation in the below video: Answer: -WMF WMF: filename::get_filename(in)= begin let string("") l_filename=string_substring(in.data.region); filename::string_concat($AI_SERIAL,"/",l_filename.dat); end; out::reformat(in)= begin out::in.data; end; OUTPUT DML-: DML record string(int) filename; string(integer(4)) file_contents; end; RMF: filename::get_filename(in)= begin filename::string_concat($AI_SERIAL,"/",in.filename); end; out::reformat(read,filename,in)= begin out.file_contents::read; out.filename::filename; end; Please view my youtube channel  DataPundit
Read more
Image
  Metaprogramming in Abinitio 1. How to create output DML dynamically based in INPUT DML 2. How to create intermediate transform( XFR) dynamically based on INPUT DML      Please See my you tube video for explanation : PART 1 PART 2 For Example, let us say, we have an Input DML as below-: cat input.dml record string(",") name; decimal(",") age; decimal(",") salary; string(",") aadharid; date("yyyy-mm-dd")(",") joiningdate; string(",") mobileno=NULL; string(",") dlno=NULL; string(",") passportnumber=NULL; end; (1.1) prepare a new DML based on input DML i.e. add fields, remove fields, modify type Graph based parameters: ===================================================================== input_dml=$DIR/input.dml  [interpretation = constant] input_dml_info =$[read_type(input_dml)]   [interpretation = pdl] /* Define functions in AB_DML_DEFS */ AB_DML_DEFS= $[ out:: dynamic_dml_gen(input_dml_info)= beg...
Read more

Next In Sequence in ABinitio | How next_in_sequence() works in MFS

Image
https://youtu.be/JdDDpjZcv-4 next_in_sequence() working in Abinitio: Definition -      within a single process(component) , this gives successive number.   next_in_sequence()>1 i.e. all records whose occurance is 2 and more in the file.      for example dataset below:    employeeName ram shyam ravi hanuman shekhar seeta geeta shayama vidushi vishakha If we process by condition next_in_sequence()>1 then the output will be [first record will be removed] shyam ravi hanuman shekhar seeta geeta shayama vidushi vishakha 2. next_in_sequence() with reformat  - rely -  FieldA 1a 2a 3a 4a 5a 6a 7a Example 1 (serial processing)--> Reformat   count=2      select:   next_in_sequence()<900      Transofom1:   out:reformat(in)=   begin   out.*::in.*;   out.Seq-No::next_in_sequence();   end;      Transform2:   out:reformat(in)=   begin   out.*:...
Read more