datapundittechblogs

  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 con

Reformat - Parameter Description   Common uses of Reformat component- 1. transforming the data 2. drop the fields  3. datatype conversion  parameters: 1. count - 1,  2 , 3  2. Select - Expression to filter the data based on condition 3. transform 0,1,2... 4. output_index out:output_index(in)= begin out.x::if(in.region=='Europe') 0 out.x::if(in.region=='APAC') 1 out.x::if(in.region=='North America') 2 end 5. output_indexes out:output_indexes(in)= begin out.x::if(in.region=='Europe') [vector 0] out.x::if(in.region=='APAC') [vector 1,2] out.x::if(in.region=='North America') [vector 2] end 6.  logging true/false  , LOGX, 7. reject threshold - abort on first reject, never abort, limit/ramp youtube videos can be seen as below: Refromat - Parameter Desciption                 Authored by datapuditeducation@gmail.com