Quick: 5] Profitability_Prod - Profitability_Actuals_Tableau

 Report: Profitability_Actuals_Tableau

>> Field Mapping Validation

4 Field Fails

>> Join validation

No fails

>> Filter Validation

no fails

Derived Field validation

no fails

>> Data Quality Checks

2 Fails

>> Action items

Comments

Post a Comment

Popular posts from this blog

QUICK: 2]Material Valuation

Report: Material Valuation (Validation and Fixes.....)\ 2]Pricing POC_Prod - Material Valuation >> Field Mapping 16 th cell (Field): Material Decription Both Fields mentioned : TXTMD/MAKTX Suggestion Fix=> Verify product_name source matches MAKT.MAKTX Final Status:   In Excel Two fields are mentioned TXTMD/MAKTX but code uses MAKT.MAKTX >> Join Validation A] Product to Sales Org "one product_id have multiple sales org" New_updated Code for Product to Sales Org:  SELECT DISTINCT      product_id,     sales_org_code,   -- ADD THIS     Item_category_group_from_material_master,     Delivering_Plant_Own_or_External  B] Product_Plant to Inventory  # CT_COMMENT=>     # In SAP Inventory comes from MARD (Storage Location / Inventory table)     # but in our code we are using gold.inventory_stock_levels.inventory_stock_levels     # This is a derived gold table, not ...
Read more

[ STRUCTURED Databricks ]

Image
 >>>>> Databricks Cluster UI (~ Ref Youtube Video : ~Mr.Ktalks Tech ) # Cluster Diagram Explanation:  Cluster : Nodes and Executors Set of VM 1 Node = 1 Executor Each Executor :  has 1/more Cores 1 Core =  1 Partition Each Core : takes 1 task and used for parallism Driver : Step 1: Write Code in Driver Step 2:  Everything get's Divides into STAGES and TASKS This is Done with help of DAG DAG: divides all jobs in form of stages and task each TASK: executes on executor each EXECUTOR: it made of essential cores each CORE: define degree of parallelism that will happen when JOB RUNS.... #  Cluster: Set of Virtual Machines to do work Creating Computer Resources for processing BigData Types: 1] All Purpose Compute 2] Job Compute 1] All-Purpose Compute [Everything] Analyze data in NB Create, Terminate and Restart Cost: Expensive 2] JOB Compute [Just to run NB as Job with ADF pipeline and Databricks] Just Support Running a NB as Job No restart Cost : L...
Read more