When you run a data profiling task, a job instance is created for the profile run. Data Profiling creates subtasks based on the options that you choose for the profile run.
To view the subtasks for a job, click the subtask link in the Subtasks column. The subtasks created for the job appears.
Data Profiling creates the following subtasks based on the profile options that you choose for the profile run:
Subtask Name
Description
Fetching the source row count
Fetches the row count for the profile run.
This subtask is created only once for a profile run.
Generating data profiling mappings
Gathers statistics based on the advanced options that you choose for the profile run.
This subtask is created only once for a profile run.
s_profiling
Runs the profile and saves the results to a secure and encrypted staging area. This subtask is created multiple times based on the advanced options for the data profiling task. For information about the advanced options, see Data Profiling.
The staging area is a temporary location in the Informatica Intelligent Cloud Services repository.
Loading data from staging area to metric store
Loads the data from the staging area to the metrics store. This subtask is created only once for a profile run.
The metrics store is located in the Informatica Intelligent Cloud Services repository where the encrypted profile results are stored. When you choose a profile run number to view the results, the service gets the profile results from the repository.
To view the details for each subtask, click the subtask link in the Instance Name column. The subtask details include instance name, asset name, asset type, started by, start time, end time, duration, state, and error message. Additional details appear for the s_profiling subtask which include processed rows, success rows, error rows, and session log. Click the Download Session Log to download the session log file.
You can view the runtime environment and the Secure Agent for the following subtasks in Data Profiling, Monitor, and Operational Insights:
•Fetching the source row count
•s_profiling
•Drilldown
•Query
Note: The Runtime Environment field displays the name of the Secure Agent Group.
You can view the following details for the Secure Agent in the session log file for the profile mapping jobs:
•Task Name. The name of the profiling task.
•Agent Group Id. The ID of the Secure Agent Group.
•Agent Group Name. The name of the Secure Agent Group.