Please enable JavaScript.

Coggle requires JavaScript to display documents.

ETL Process - Coggle Diagram

- - - - Completeness
        
        confirming that the data contains all the desired components or measures.
      - Consistency
        
        confirming that data is compatible and in agreement across all systems.
      - Conformity
        
        conforming that the data fits the required destination format
        
        schemas validation
        
        a process to ensure that the source system data schema matches the target database data schema
        
        keys are valid
        
        table relationships have been preserved
        
        convention are consistent
        
        data dictionary
        
        data lineages
        
        a process of identifying the origin of data, where it has moved throughout the system, and how it has transformed over time.
      - Accuracy
        
        conforming to the actual entity that's being measured or described.
      - Redundancy
        
        moving, transforming, or storing more than the necessary data.
      - Integrity
        
        concerns the accuracy, completeness, consistency, and trustworthiness of data throughout its life cycle.
        
        Accurate & complete
        
        trustworthy
        
        consistent
      - Timeliness
        
        confirming that data is current.