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

Compare with Current View Page History

Version 1 Next »

See architecture Impact Assesment


Data Architecture Design documents:

  • Data Architecture Blueprint :

    1. This document shows the architecture design for PCF 
    2. On the left side it denotes the sources used for PCF, it has mainly SAP ECC, BW, Gsheet, PURE, Ecoinvent ( External file)
    3. All these sources are extracting using the talend to google cloud storage and then data has been sent to  staging area to perform then to ODS to Data mart and Views, 
    4. In final step the it is connected to dashboard in Tableau

                                                       

         The diagram represents the data lineage in PCF project 



  •  Data Model :

     

Usage : fact_pcf is use by dashboards PCF, product list and breakdown to display PCF of a couple Finished Product / Site


usage : Fact_biogenic is to display on the dashboard the total amount of carbon of a couple Finished Product / Site


                  Data knowledge document represents the architectural artificats, it contains informations on source info, CRUD objects etc, below are the list of tabs and information present in the tabs: 

    1. Source info : In this tab , there is information about sources and filters used in the project
    2. Data Lineage/Talend Job : In this tab THere is information on the data model and talend jobs used to create it
    3. CRUD Business Objects : This tab has information on the data objects/Data fields and its operation for example whether it is Created Read Updated or deleted, in this project most of the data object and data fields have been read in the GCP
    4. Technical Data Dictionary : This tab contains the information on the data fields and its technical name, table etc
    5. Table definitions : This tab has information on the tables  and its definitions
    6. Data governance : This tab represent the data goverance information , it has been used by data goverance team
    7.  Links : This tab has links on the infromation of the data rules, specification rules for creation of tables and BW query etc
  • No labels