Syniti ADMM Profile Data Source: Analyze Equivalent

Answered

Sandeep Kumar

• June 19, 2023 17:33

Hello Experts What is equivalent of Analyze in ADM when Compared to ADMM version .

 

We want to get a report with below attributes

 

• Record counts for each table
• Unique values for each field
• Unique value count for each field
• Blanks for each field
• Fields used and not used
• Minimum/maximum values for each field
• Maximum field length
• Field datatype
• Field data type length

0

• 

  Rakesh Ananthuni

  • June 20, 2023 09:05

  Hi Sandeep,

  Note: All users can view profile data, but only Admins, Business Users and Authors can profile objects.

  Only tables and views for a system can be profiled.

  To profile objects:

  1. Verify you’re in the Catalog module of the Syniti Knowledge Platform.

     Or

     Select Catalog from the Home menu to navigate to the Catalog module of the Syniti Knowledge Platform.

  2. Search for the system.

  3. Ensure that the system has a connection where the Usage is set to Profiling. Refer to Set the Usage of a Connection for more information

  4. Click the Objects tab.

  5. Click the CHILD OBJECTS button to drill down to the object you want to profile.

  6. Click the Profiling tab.

  7. Click Profile this object.

  8. Select a Connection.

  9. Select an SKP Connector.

  10. Click the check button to profile the object.

  For details about a specific field, hover over the Help icon.

  For more information about profiling objects, click the Page help icon on the Site menu.

   

  Regards,

  Rakesh

  0

Please sign in to leave a comment.