Table of Contents

Search

  1. Preface
  2. Part 1: Introduction
  3. Part 2: Configuring Hub Console Tools
  4. Part 3: Building the Data Model
  5. Part 4: Configuring the Data Flow
  6. Part 5: Executing Informatica MDM Hub Processes
  7. Part 6: Configuring Application Access
  8. Appendix A: MDM Hub Properties
  9. Appendix B: Viewing Configuration Details
  10. Appendix C: Row-level Locking
  11. Appendix D: MDM Hub Logging
  12. Appendix E: Table Partitioning
  13. Appendix F: Collecting MDM Environment Information with the Product Usage Toolkit
  14. Appendix G: Informatica Platform Staging
  15. Appendix H: Informatica Platform Mapping Examples
  16. Appendix I: Glossary

Load Batch Job on System Columns

Load Batch Job on System Columns

The effect of a Load batch job varies for some system columns.
The following table describes the effect that a Load batch job insert operation and update operation have on system columns:
System Column
Type of Load Batch Job Operation
Effect on System Column
CREATE_DATE
Insert
The Load batch job populates these columns with data from the staging table. The Load batch job populates these columns with the column default value if the staging table column has a null value.
CREATE_DATE
Update
The column in the base object retains the original value.
CREATOR
Insert
The Load batch job populates these columns with data from the staging table. The Load batch job populates these columns with the column default value if the staging table column has a null value.
CREATOR
Update
The column in the base object retains the original value.
UPDATE_BY
Insert
The Load batch job populates these columns with data from the staging table. The Load batch job populates these columns with the column default value if the staging table column has a null value.
UPDATE_BY
Update
The column in the base object retains the original value.
The Load batch job populates the column in the cross-reference table with data from the staging table.
LAST_UPDATE_DATE
Insert
The Load batch job populates the LAST_UPDATE_DATE column in the base object table and cross-reference table with SYSDATE.
LAST_UPDATE_DATE
Update
The Load batch job populates the LAST_UPDATE_DATE column in the base object table and cross-reference table with SYSDATE.
SRC_LUD
Insert
The Load batch job populates the SRC_LUD column with value from the LAST_UPDATE_DATE column.
SRC_LUD
Update
The Load batch job populates the SRC_LUD column with value from the LAST_UPDATE_DATE column.
DELETED_IND
Insert
The Load batch job populates these columns with data from the staging table. The Load batch job populates these columns with the column default value if the staging table column has a null value.
DELETED_IND
Update
The column in the base object retains the original value.
DELETED_BY
Insert
The Load batch job populates these columns with data from the staging table. The Load batch job populates these columns with the column default value if the staging table column has a null value.
DELETED_BY
Update
The column in the base object retains the original value.
DELETED_DATE
Insert
The Load batch job populates these columns with data from the staging table. The Load batch job populates these columns with the column default value if the staging table column has a null value.
DELETED_DATE
Update
The column in the base object retains the original value.

0 COMMENTS

We’d like to hear from you!