Deliverable 2 · ODS Metadata Inventory

ODS Metadata Inventory

A complete catalog of the Skyworks ODS estate: every database, table, view, column, and programmable object, profiled to depth. Completed in Phase 1, this inventory becomes the foundation for the Phase 2 lineage map and Bronze / Silver / Gold classification.

Engagement

Skyworks ODS Assessment

Environment

Sandbox · db-ivnEntODSsbx01

Phase

Phase 1 · weeks 1-3

Scope

18 databases, full metadata

Prepared for

Delivered by

Inventory at a Glance

One catalog, profiled to the column

Profiled against the Sandbox environment (db-ivnEntODSsbx01). Across all 18 in-scope databases, the inventory captures structural metadata at every level: for each column, its data type and nullability, plus key details where the column carries a key role.

Columns profiled

273,012

Each column carries its data type and nullability, the granularity lineage tracing and layer classification require.

Databases

18

Tables

5,141

Views

4,060

Programmable objects

4,145

Programmable objects breakdown

3,867 stored procedures · 255 functions · 23 triggers · the transformation logic that will be parsed for lineage.

Deepest catalog

Skyworks_ODS alone holds 109,581 columns across 2,711 tables · the central hub anchoring the assessment.

Data Volume Landscape

28.2 billion rows, concentrated in four estates

Row-count profiling shows volume is heavily concentrated: four databases each hold 6 to 9 billion rows, together over 99% of all rows in the estate. This concentration is where classification and cost-simulation effort will focus.

Row count by database (of 28.2B)

Skyworks_ODS

9.20B

LIB_ECC_RTP

6.76B

Skyworks_WH

6.15B

Skyworks_ODS_Archive

6.05B

All others

44.5M

SAP_Snapshot_AdvPlan

36.4M

Largest individual tables

LIB_ECC_RTP.sap.JCDS1.12B

Skyworks_WH.sd.FactVersions1.10B

LIB_ECC_RTP.sap.JEST1.09B

Skyworks_ODS_Archive.sdendcustomer.FactEndCustomerVersions_Archive953.7M

Skyworks_WH.sd.FactSalesAndDemandPlanningArchive952.3M

Long tail

443 tables are empty (0 rows), candidate deprecations to weigh in the transition backlog.

Fact-heavy warehouse

The largest tables are demand-planning and SAP document fact tables · the high-value analytical core.

Object & Column Composition

What the catalog is made of

Data-type and activity profiling surface both the shape of the data and how much of the estate is actively maintained versus dormant.

Column data types (273,012 total)

nvarchar

157,424

decimal

38,342

int

22,113

date

12,515

bigint

8,440

float

6,247

66%

Nullable

Loosely constrained

178,969 of 273,012 columns are nullable · a data-quality signal to weigh during classification.

1,707

Active objects

Modified 2024 or later

Of 4,145 programmable objects, 1,707 were touched recently; 2,438 are older · a dormant tail for lineage context.

5,179

Keyed columns

Join backbone

Columns carrying key roles define the relationships that drive downstream lineage and join-complexity scoring.

What This Enables

The foundation for Phase 2

With the full metadata catalog in place, the engagement moves into lineage mapping and classification. Each downstream deliverable draws directly on this inventory.

D3ODS Lineage Map

Column-level metadata and the 4,145 inventoried programmable objects feed end-to-end lineage from upstream sources through transformations to consumption.

D4Dataset Classification

Row counts, key structure, and nullability inform usage scoring to classify every dataset into Bronze / Silver / Gold layers.

D5Architecture Baseline

The volume profile of 28.2 billion rows anchors the current-state alignment percentage and gap analysis against the target medallion architecture.

Delivered

Full inventory delivered as an Excel workbook, 22 sheets spanning summary aggregates, object lists, and per-database column detail.

Deliverable 2 · Complete

The ODS is fully cataloged

Prepared by Findability Sciences as part of the Skyworks Solutions ODS Assessment engagement. Every database, table, view, column, and programmable object across the 18 in-scope databases is now inventoried to depth. The engagement now proceeds to lineage mapping and dataset classification.

Deliverable

D2 · Complete

Columns profiled

273,012

Rows cataloged

28.2 billion

Prepared for

Delivered by