Post reply

Data Profling tables within SQL Server w/out SSIS Mean_Value, Min_Value, Max_Value

  • June 18, 2015 at 8:29 am

    #305144

    Hello everyone,

    I have been giving the task of profiling databases and all the tables within it.

    Right now I'm collecting the following:

    Null_Count

    Null_Percentage

    Total_Record_Count

    I'm looking to capture Mean_value, Min_value, and Max_value and the unique_count.

    Any suggestions that would point me in the right direction of capturing this information?

    Regards,

    Jonathan

  • June 18, 2015 at 8:38 am

    #1806401

    Jonathan Marshall (6/18/2015)

    Hello everyone,

    I have been giving the task of profiling databases and all the tables within it.

    Right now I'm collecting the following:

    Null_Count

    Null_Percentage

    Total_Record_Count

    I'm looking to capture Mean_value, Min_value, and Max_value and the unique_count.

    Any suggestions that would point me in the right direction of capturing this information?

    Regards,

    Jonathan

    Mean_Value of what?

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • June 18, 2015 at 12:22 pm

    #1806499

    Mean max min values of numeric columns.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply