Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

...