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?

  • June 18, 2015 at 12:22 pm

    #1806499

    Mean max min values of numeric columns.

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

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