Table of Contents

Search

  1. Preface
  2. Data Profiling
  3. Profiles
  4. Profile results
  5. Tuning data profiling task performance
  6. Troubleshooting

Data Profiling

Data Profiling

Profile results

Profile results

When you run a
data profiling
task on a data source, the profile extracts and displays the column statistics from the data source, such as null values, distinct values, data types, and patterns. You can analyze the profile results to make business decisions.
For example, you are a data analyst and you want to analyze and report potential data issues in the Customer table such as the completeness and validity of addresses and email IDs. The accuracy of this critical data impacts the effectiveness of the company's marketing campaign. To accomplish this task, you create a
data profiling
task on the table, add Verifier and Cleanse assets as rules, and then run the profile. You can view the results or export them to a file to analyze the data.
When you open a profile after you run it, the following tabs appear:
  • Results. You can view the profile results on this tab.
  • Definition. You can view and edit the profile definition on this tab.
  • Rules. You can view and edit the rules on this tab.
  • Schedule. You can view and edit the schedule, email notification options, and advanced options on this tab.
You can edit the profile-related options, rules, schedules, and advanced options as necessary and run the profile again. You can run a profile multiple times and view the profile results for each run. You can also compare profile runs, compare columns in a profile run, and export the profile results to a Microsoft Excel file.

0 COMMENTS

We’d like to hear from you!
Nazaret Cornide Basanta - November 15, 2023

¡Hi!

Can I associate the result of a profiling to a data set so that this % can be seen in the Data Governance and Marketplace modules?

Thanks

Informatica Documentation Team - November 16, 2023

Hi Nazaret Cornide Basanta,

We’re working to address your comments and will get back to you.

Thanks,

Informatica Documentation team