Customer Segment Mapping

The customer segment data is loaded from the W_RTL_CUSTSEG_DS.dat file or from AI Foundation exports of the segment data back into the data warehouse table W_RTL_CUSTSEG_D. The data is exported to PDS for use in Assortment Planning, which has the ability to select a customer segment to use for AIF integrations like Demand Transference results.

Measure	Target Table	Target Column	Data Source
Segment ID	W_PDS_CUSTSEG_D	CUSTSEG_ID	W_RTL_CUSTSEG_D.CUSTSEG_ID
Segment Name	W_PDS_CUSTSEG_D	CUSTSEG_NAME	NVL(W_RTL_CUSTSEG_D.CUSTSEG_NAME,'UNKNOWN SEGMENT')
Segment Desc	W_PDS_CUSTSEG_D	CUSTSEG_DESC	W_RTL_CUSTSEG_D.CUSTSEG_DESC
Segment Type	W_PDS_CUSTSEG_D	CUSTSEG_TYPE	W_RTL_CUSTSEG_D.CUSTSEG_TYPE
Segment Source Type	W_PDS_CUSTSEG_D	CUSTSEG_SRC_TYPE	W_RTL_CUSTSEG_D.CUSTSEG_SRC_TYPE
Segment Organization Hierarchy Key	W_PDS_CUSTSEG_D	ORG_HIER_KEY	W_RTL_CUSTSEG_D.ORG_HIER_KEY