Skip to content

No scale specified for DECIMAL columns in create-dw.txt #3

Description

@klightspeed

The SQL queries to create the DimProduct and FactSalesOrder tables do not specify a scale, and as a result are created with a default scale of 0.

From the provided data, it looks like they should be created with a scale of 2 - e.g. DECIMAL(18, 2)

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Fields

    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions