How to connect to Oracle Cloud (Autonomous) Database from Incorta On-Prem
A simple guide to getting connected to Oracle Cloud (Autonomous) Database
Knowledge Base Articles
Exploratory Data Analysis using SweetViz and Incorta Notebook
You can generate the data profiling report using SweetViz from Incorta Notebook. This article shows you step by step instructions.
Generate profile reports using Pandas Profiling package within Incorta Notebook
Learn how to generate profile reports using Pandas Profiling package in Incorta Notebook
Run SQL Queries from PySpark and Incorta Notebook
Incorta Notebook enables you to write SQL queries to create your data pipeline in Incorta Materalized Views.
Level Based Aggregate using Incorta Materialized View
Overview This is the second part of the articles that discuss about level-based measure. The essential of a level based measure is an aggregation that are calculated at a specific level of details and the result can be repeated at the lower level...
Level-Based Aggregate in Incorta
Compare the discounts given in different area, business units and at the different levels of details.
Install the Python Package in Incorta Cloud
Learn how to install the python package in Incorta Cloud!
Data Alert for Current Running Job
An Incorta job runs for more than 40 hours and none of us noticed until business users contacted us and asked why they do not see the updated data from the dashboard. Incorta provided us the Long Spinning Job Alert before. Why does it not work?
Calculating Z-Score with Incorta
Have you ever needed to calculate a Z-score?
JSON - Avro Extractor Tool and Configuring Kafka Data Sources
This article provides more information about the Avro Extractor tool that generates an Avro file from a provided JSON file.
Kafka Overview
Apache Kafka is a distributed publish-subscribe messaging system that can handle a high volume of data and enables you to pass messages from one end-point to another.
How Joins Work in Incorta
Introduction Incorta supports the following types of joins: One-to-one (1:1) Many-to-one (M:1) Many-to-many (M:M) joins using Materialized Views Example: Simple Many-to-one (M:1) Join Tables: Sales table Customer table The Sales table has mult...
Configure an Incorta v4 Cluster using the CMC step by step
Prerequisites: CMC instance is up and runningNode agent instance(s) are up and runningZookeeper is up and running (either shipped with incorta or a clustered zookeeper)An empty schema is created (either oracle metadata or MySQL metadata)A common/shar...
