You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Next »

Basic Info  

Customer data in the Data Lake is composed of 3 different table views:

  1. DIM_material_type
  2. DIM_package_type
  3. DIM_product_line
  4. DIM_material_group
  5. DIM_material
  6. DIM_product hierarchy

Project Space: prj-data-pricing-dev
See how this entity relates to the others in the pricing data model here.

Tables & Attributes:

View ID: prj-data-pricing-dev.DataOcean.V_DIM_material_type

fullnamemodetypedescription
material_type_key
STRING
material_type_id
STRING
source_system_id
STRING
material_type_name
STRING
meta_source_system
STRING
inserted_date
TIMESTAMP
updated_date
TIMESTAMP
delete_flag
BOOLEAN


View ID: prj-data-pricing-dev.DataOcean.V_DIM_package_type

fullnamemodetypedescription
package_type_key
STRING
package_type_id
STRING
source_system_id
STRING
package_type_name
STRING
meta_source_system
STRING
inserted_date
TIMESTAMP
updated_date
TIMESTAMP
delete_flag
BOOLEAN


View ID: prj-data-pricing-dev.DataOcean.V_DIM_product_line

fullnamemodetypedescription
product_line_key
STRING
product_line_id
STRING
product_line_name
STRING
meta_source_system
STRING
inserted_date
TIMESTAMP
updated_date
TIMESTAMP
delete_flag
BOOLEAN


View ID: prj-data-pricing-dev.DataOcean.V_DIM_material_group

fullnamemodetypedescription
material_group_key
STRING
material_group_id
STRING
source_system_id
STRING
material_group_name
STRING
meta_source_system
STRING
inserted_date
TIMESTAMP
updated_date
TIMESTAMP
delete_flag
BOOLEAN


View ID: prj-data-pricing-dev.DataOcean.V_DIM_material

fullnamemodetypedescription
material_key
STRING
material_id
STRING
source_system_id
STRING
material_name
STRING
arch_type
STRING
material_type_key
STRING
material_type_id
STRING
material_type_name
STRING
base_unit_of_measure
STRING
product_line_e2e
STRING
commercial_material_group_id
STRING
commercial_material_group_name
STRING
product_line_01_key
STRING
product_line_01_id
STRING
product_line_01_name
STRING
product_line_02_key
STRING
product_line_02_id
STRING
product_line_02_name
STRING
product_line_03_key
STRING
product_line_03_id
STRING
product_line_03_name
STRING
product_line_04_key
STRING
product_line_04_id
STRING
product_line_04_name
STRING
product_line_05_key
STRING
product_line_05_id
STRING
product_line_05_name
STRING
product_line_06_key
STRING
product_line_06_id
STRING
product_line_06_name
STRING
product_family_code
STRING
material_group_key
STRING
material_group_id
STRING
material_group_name
STRING
material_group_package_type_id
STRING
material_group_package_type_name
STRING
hierarchy4
STRING
product_hierarchy_key
STRING
product_hierarchy_id
STRING
product_hierarchy_name
STRING
package_type_key
STRING
package_type_id
STRING
package_type_name
STRING
meta_source_system
STRING
inserted_date
TIMESTAMP
updated_date
TIMESTAMP
delete_flag
BOOLEAN


View ID: prj-data-pricing-dev.DataOcean.V_DIM_product_hierarchy

fullnamemodetypedescription
product_hierarchy_key
STRING
product_hierarchy_id
STRING
source_system_id
STRING
product_hierarchy_name
STRING
meta_source_system
STRING
inserted_date
TIMESTAMP
updated_date
TIMESTAMP
delete_flag
BOOLEAN


Other Info & Comments  

-

  • No labels