5.1.8.1 Approach 1

As per Approach 1, follow these steps:

1. Create a view on STG_CUSTOMER_MASTER table with FIRST_NAME, MIDDLE_NAME and LAST_NAME concatenated and identify this column as NAME.
2. Configure the name column from the view in FSI_DIM_LOADER_SETUP_DETAILS
3. Increase the size of DIM_CUSTOMER_TL.NAME column.
4. Disable the unique index on DIM_CUSTOMER_TL.NAME or append Customer_code to the NAME column.
5. The NAME column will be populated into the DIM_CUSTOMER_TL.NAME column.