...
Project Space: gcp-sqo-data-pricing-d
See how this entity relates to the others in the pricing data model here.
Additional Info & Comments
...
Data will be refreshed from SAP-BW into data ocean on a daily basis
Will extract forecast data from CPCOPC04 data latest month of transactions on a daily basis and refresh into data ocean. This will include next 24 months of data
- Will extract last 27months data from MVCOPA06 SAP-BW query
- Stage table will be partitioned on meta_stg_Insert_date
- ODS table will be partitioned on meta_ods_Insert_date
- FACT_bom_raw, FACT_bom_flc_raw and FACT_bom_enriched tables will be partitioned on running_month
...
Tables & Attributes
...
View ID: gcp-sqo-data-pricing-d.DataOcean.V_FACT_bom_raw
View ID: gcp-sqo-data-pricing-d.DataOcean.V_FACT_bom_flc_raw
...