Adventureworks.Sales.Purchases.DataManagement.pdf: page 28 (Section)

Properties

KeyValue
excerpt         Sales Transformation      sa les_ o rder_ id No In teger ID o f the o rder Ex tra cted fro m Adven tureWo rks Sa lesOrderDeta il. sa les_ o rder_ n um b er No Va rcha r The o rder n umb er a sso cia ted with a n o rder Ex tra cted fro m Adven tureWo rks Sa lesOrderHea der. p ro duct_ sta n da rd _ co st_ o n _ da y No Decim a l The sta n da rd co st o f the p ro duct tha t da y Ca lcula ted b y Kettle. ship _ da te_ id No In teger ID o f the o rder ship da te Ex tra cted fro m Adven tureWo rks Sa lesOrderHea der. ship _ da te_ da teti me No Da teti me The da te when the o rder wa s ship p ed Ex tra cted fro m Adven tureWo rks Sa lesOrderHea der. sa les_ p ro fit No In teger Ca lcula ted b y sub tra ctin g Pro duct Un it Price - Sta n da rd Pro duct Co st, times the o rder q ua n tity . Pro duct un it p rice a n d q ua n tity ex tra cted fro m Aven tureWo rks Sa leOrderhea der. Ca lcula ted sta n da rd p ro duct co st fro m DW Kettle transformation  fact_sales. ktr 
page28
section_index27

Relationships

Contains

Diagram

graph TD
    n4ff5593726ff5ae5890f39275f5ab236["Adventureworks.Sales.Purchases.DataManagement.pdf: page 28"]
    nf240004cab015ee9a37183bdd1c54d35["Adventureworks.Sales.Purchases.DataManagement.Slides.pdf"]
    nf240004cab015ee9a37183bdd1c54d35 -->|Contains| n4ff5593726ff5ae5890f39275f5ab236

Evidence

Rendered

graph TD n4ff5593726ff5ae5890f39275f5ab236["Adventureworks.Sales.Purchases.DataManagement.pdf: page 28"] nf240004cab015ee9a37183bdd1c54d35["Adventureworks.Sales.Purchases.DataManagement.Slides.pdf"] nf240004cab015ee9a37183bdd1c54d35 -->|Contains| n4ff5593726ff5ae5890f39275f5ab236

Live rendering added for this hosted example via mermaid.js (CDN). The ekos docs generate tool itself ships the diagram as source only, to stay fully offline by default.