Product
Global dimensional table for Product (dim_product_gbl_DDS__v) sourced from CRM.
| Global DDS Field | Field Type |
Source Data Connector: Global Table: crm_product_gbl_ods__v |
Source Data Connector: Global Table: crm_product_gbl_ods__v & map_crm_product_gbl_ods__v |
|---|---|---|---|
| dim_global_product_id__v | bigint | n/a | n/a |
| native_id__v | varchar(18) | |crm_product_vod_id__v|related_id__v|related_source__v| | |crm_product_vod_id__v||| |
| global_product_name__v | varchar(240) | parent_product_name__vIf no dim_global_product__v.parent_product_name__v, use crm_product_gbl_ods__v.global_product_name__v |
parent_product_name__vproduct_type__v = detail (case insensitive) If no dim_global_product__v.parent_product_name__v, use crm_product_gbl_ods__v.global_product_name__v |
| raw_product_name__v | varchar(240) | global_product_name__v | global_product_name__v |
| brand__v | varchar(240) | map_crm_product_gbl_ods__v.display_name__v | |
| product_country__v | varchar(240) | map_crm_product_gbl_ods__v.country__v | |
| product_type__v | varchar(765) | product_type__v | product_type__v |
| parent_product_id__v | varchar(765) | parent_product__v | parent_product__v |
| parent_product_name__v | varchar(765) | global_product_name__v for corresponding record where parent_product__v=native_id__v (look up to same table)&end_date__v is null for lookup |
global_product_name__v for corresponding recordwhere parent_product__v=native_id__v(look up to same table)&end_date__v isnull for lookup |
| therapeutic_area__v | varchar(765) | therapeutic_area__v | therapeutic_area__v |
| market_name__v | varchar(110) | map_crm_product_gbl_ods__v.market_name__v | |
| market_id__v | varchar(18) | map_crm_product_gbl_ods__v.market_id__v | |
| therapeutic_class__v | varchar(765) | therapeutic_class__v | therapeutic_class__v |
| company_product__v | boolean | company_product__v | company_product__v |
| display_in_reports__v | boolean | map_crm_product_gbl_ods__v.display_in_reports__v | |
| last_modifed_date__v | timestamp | last_modifed_date__v | last_modifed_date__v |
| start_date__v | date | start_date__v | start_date__v |
| end_date__v | date | end_date__v | end_date__v |
