Fact & Dimension Tables in EI

Delivery Status Dimension Table
Column DescriptionidIt is the campaign delivery status that gets mapped to dim_campaign_delivery_status_id of the contact and response tables nsadmin_deliver...
Tue, 21 May, 2019 at 11:08 AM
Inventory Items Dimension Table
Column Description colorStandard field to capture color of an item sub_classStandard field to capture an inventory item attribute is_validMarked 1 for val...
Tue, 21 May, 2019 at 11:09 AM
Customer Summary View Dimension Table
Column Descriptionuser_idDenotes user identifier set by Capillary Systemsku_purchasedDenotes total quantity of products purchased by customer so farsku_retur...
Tue, 21 May, 2019 at 11:09 AM