How to convert complex Oracle sqls in the Incorta way
This article elaborates the steps to convert complex Oracle SQLS or views to Incorta.
Knowledge Base Articles
OTBI Lineage
Use the Incorta OTBI Lineage dashboard to determine the mapping between Oracle tables and VOs.
Parse a JSON string from column to flattened structure in Incorta
Question How do I parse a JSON string from column to flattened structure in Incorta? Answer Assuming a Incorta table has a column with JSON string then here is a sample pyspark code which you can use to create a Materialized view in Incorta - from...
Access AWS services from an Incorta MV
Learn how to access AWS services from an Incorta Materialized View.
Issue with converting a Pandas DataFrame to a Spark DataFrame
What to do if you receive the 'iteritems' error when trying to convert a Pandas DataFrame to Spark DataFrame.
Dynamic Forms in Materialized Views
Streamline your data investigation with the use of dynamic forms!
Time Series Forecasting in an Incorta MV
This overview of time series analysis in Incorta will ensure that you can move into the predictive analytics space with your data!
How to Check the Version of a Python Package
Sometimes you need to check the version of a Python package. Find out how!
Incorta Notebook Best Practices
We bet there is one thing in here you didn't know about working with notebooks in Incorta.
Use hash keys to compare two records in PySpark
Use hash keys to simplify duplicate record identification.
Informatica ETL migration to Incorta
Introduction When replacing your current Informatica ETL processes, there are many approaches you can take to seamlessly transition to Incorta. This document will cover some of the best practices around how to manage an Informatica migration to Inco...
How to Publish Oracle BIP files to UCM and Ingest them into Incorta
Learn how to publish Oracle BIP files to UCM and then ingest them into Incorta.
