Wednesday, July 25, 2012

Delete Process Parameters in IFB

These are the parameters which are only applicable to EIM Delete process and are written with in the Process section in an IFB file used for delete process. They are :-

CASCADE DELETE ONLY

  • Optional parameter that tells whether to delete the child records when a parent record is deleted.
  • Valid values are TRUE or FALSE.
  • Default value is FALSE.
  • If set to FALSE, EIM deletes the parent record and sets the foreign key column in the child records to NULL.
  • Example: CASCADE DELETE ONLY = TRUE


CLEAR INTERFACE TABLE

  • Optional parameter that specifies whether the existing rows for the particular batch number should be deleted.
  • Valid values are TRUE or FALSE.
  • Default value depends upon the type of delete being done.
  • For DELETE EXACT, default value is FALSE, for others, it is TRUE.
  • Example: CLEAR INTERFACE TABLE = FALSE


DELETE ALL ROWS

  • Optional parameter that specifies whether to delete all the rows from the base table.
  • Valid values are TRUE or FALSE.
  • Default value is FALSE.
  • Care should be taken while setting this parameter to TRUE in case of party EIM tables.
  • In case of party EIM tables, always use DELETE MATCHES when deleting records of particular party type.
  • Example: DELETE ALL ROWS = TRUE


DELETE EXACT

  • This parameter tells the EIM to use user key matching algorithm with rows in the EIM table to perform deletion.
  • Valid values are TRUE or FALSE.
  • Default value is FALSE.
  • Example: DELETE EXACT = TRUE
  • Always use this parameter to delete records from the non target base tables.


DELETE SKIP PRIMARY

  • This parameter tells whether to do a cascade update on the primary child column in the parent table.
  • If the primary address record is deleted, then the primary address column in the parent table is set to NULL, when this parameter is set to TRUE.
  • If set to FALSE, NO_MATCH_ROW_ID gets stored in the primary child column of the parent table.
  • Valid values are TRUE or FALSE.
  • Default value is TRUE.
  • Example: DELETE SKIP PRIMARY = FALSE


DELETE MATCHES

  • Optional parameter that specifies a conditional expression to select the records which has to be considered for deletion.
  • Example: DELETE MATCHES = S_ORG_EXT, (NAME LIKE “HP%”)
  • The literal specified inside the parentheses is the condition that occurs after the WHERE clause in any SQL statement.
  • This parameter can be used only to delete records from the target base table.


DELETE ROWS

  • This parameter specifies whether rows from the particular table should be deleted.
  • Example: DELETE ROWS = S_ADDR_ORG, FALSE ? This example restricts the deletion of records from the S_ADDR_ORG table.
  • Care should be taken while setting FALSE value, because it might result in dangling foreign key references.


UPDATE ROWS

  • This parameter specifies whether foreign references should be updated.
  • Valid values are TRUE or FALSE.
  • Default value is TRUE.
  • Example: UPDATE ROWS = S_CONTACT, FALSE
  • This above example restricts any update including the updating of foreign key references in the S_CONTACT table while performing the EIM Delete.
  • Care should be taken while setting FALSE value, because it might result in dangling foreign key references.

No comments:

Post a Comment