Day0 Customer Data Population

UDS requires Customer data to be populated in the Canonical schema to enable its consumption in creating 360 views.

About this task

The prerequisites for this installation are data mapping activity and operational detail gathering. The details of these activities and corresponding roles and responsibilities are provided in below document: For more information, refer HCL Unica MaxAI Canonical Redbook.

The Unica team will use this information to create bespoke ETL pipelines for extracting data from your databases and loading it to Canonical schema. A follow-up exercise of data mapping is Data Analysis for identifying the business date to be used in UDS’s ETL Date control table during the Day0 load. Edit the DDL HCL_Unica_CDM_<25.1.1>.zip/ddls/Step8_date_control.sql to assign correct values, as explained below:

Assuming that day 0 is executed on 2nd Jun 2025.

  • For entries with USES_BUSINESS_OR_TIMESTAMP = 'B'
    • Edit values for fields PREVIOUS_BUSINESS_DATE, CURRENT_BUSINESS_DATE and NEXT_BUSINESS_DATE.
    • PREVIOUS_BUSINESS_DATE for Day 0 will be the minimum of the data from which data will be loaded.

      Example : if data having minimum data of 01-01-2025 then PREVIOUS_BUSINESS_DATE should be 31-12-2024 CURRENT_BUSINESS_DATE and NEXT_BUSINESS_DATE should be one day ahead of the previous business date respectively. CURRENT_BUSINESS_DATE: 02-06-2025 NEXT_BUSINESS_DATE : 03-06-2025

  • For entries with USES_BUSINESS_OR_TIMESTAMP = 'T'
    • Edit values for the field CURRENT_START_DATETIME and PREVIOUS_START_DATETIME.

After finalizing the values in this DDL, complete the following steps (only for Day0) to truncate and reload the ETL_DATE_CONTROL table:

Procedure

  1. Log in to the Oracle server using the environment-specific user ID credentials.
  2. Connect to OracleDB with user ID cdp_metadata.
  3. Upon connection, execute the following commands in the same sequence:
    1. Delete the table cdp_metadata.ETL_DATE_CONTROL.
    2. Delete the table cdp_metadata.DBT_ETL_HOLIDAYS.
    3. Execute the script "HCL_Unica_CDM_<25.1.1>.zip/ddls/Step8_date_control.sql".

Results

Once the process is in place, the scheduled execution of UDS pipelines, for populating 360 views, starts.