Data Profiling using Intelligent Cloud Services

I began by logging into Informatica Intelligent Cloud Services.

Login to Informatica

After accessing the platform, I selected the Data Profiling option.

Select Data Profiling
Step 1: Connect to Oracle Database

To facilitate the process, I used SQL Developer to connect to the Oracle database, which I downloaded and installed from Oracle's official site.

SQL Developer Setup

I obtained the necessary credentials and connection details from Oracle SQL Developer.

Connection Details
Step 2: Install Informatica Cloud Secure Agent

Next, I installed and ran the Informatica Cloud Secure Agent, which enabled me to establish a connection to the Oracle Database.

Install Informatica Cloud Secure Agent
Informatica Secure Agent Running
Step 3: Data Profiling

Once the connection was set up, I ran a profile using the Data Profiling tool to gather insights into the quality and structure of the data.

Running Data Profiling
Data Profiling Insights
Data Profiling Results
Step 4: Reviewing the Results

The results were displayed clearly, offering details about the data.

Profiling Results
Data Insights
Step 5: Comparing Data Quality

I was able to gain several insights from this analysis by comparing the columns' qualities.

Comparing Columns Quality
Quality Comparison
Step 6: Profile Comparison

Additionally, I compared profiles in terms of their quality.

Profile Comparison
Profile Quality Comparison
Final Data Profiling Results