Data & Schemas Knowledgebase
A solid data foundation leads to analytics. Build that foundation here.
cancel
Showing results for 
Search instead for 
Did you mean: 

Knowledge Base Articles

Find and Fill Missing Data in Incorta Notebook

Find and Fill Missing Data in Incorta NotebookIn this article, you will learn how to find and fill missing values in Incorta Notebook. Copy below find null value reusable codes.  from pyspark.sql.functions import isnan, when, count, col, lit def colu...

suxinji_0-1646672041325.png suxinji_1-1646672041312.png
suxinji by Employee Alumni
  • 974 Views
  • 0 comments
  • 0 kudos

Regular vs. Analyzer Views

Introduction Incorta offers two types of business schema views- regular and analyzer (Runtime or Incorta) views and both are useful to support various use cases. What you should know before reading this article We recommend that you be familiar with...

tile.jpg

Handling Deletes

There are a number of strategies that can be implemented depending on the size of your data and whether the deleted records can be easily identified.

delete.jpg
dylanwan by Employee
  • 1656 Views
  • 0 comments
  • 0 kudos

Using Formula Columns in Business Views

Introduction A formula column contains an expression that, depending on the expression and the expression context, returns a scalar or an array of values of a specific data type. An expression can consist of built-in functions, built-in system variab...

Screen Shot 2022-03-03 at 3.11.45 PM.png
RichC by Employee
  • 1494 Views
  • 0 comments
  • 0 kudos

Connecting to Data

Introduction Incorta has a wide variety of external data source connectors. A connector specifies how Incorta can connect to an external system or application , ingest data and publish to destinations.  Incorta includes many out-of-the-box connector...

Screen Shot 2022-03-03 at 3.17.26 PM.png
RichC by Employee
  • 2101 Views
  • 0 comments
  • 1 kudos

Data Load Strategy

Introduction This article discusses the procedures and best practices for Data Load Strategy. What you should know before reading this article We recommend that you be familiar with these Incorta concepts before exploring this topic further.  Importi...

Screen Shot 2022-03-03 at 3.22.21 PM.png
RichC by Employee
  • 3868 Views
  • 0 comments
  • 0 kudos

Handling Hierarchical Data

IntroductionIf you need to represent hierarchical data in Incorta, we provide several features that make this data modeling technique easier. Common use cases for hierarchy include HR org chart, chart of accounts, and even your Incorta dashboards' fo...

hier.jpg
DustinB by Employee
  • 2184 Views
  • 0 comments
  • 1 kudos

Snapshotting Data

Introduction If you need to create point in time reporting in Incorta, you may need to implement a snapshotting strategy.  Often the source application itself will track changes to its data and thus you can get a full historical view of changes to d...

snapshot.jpg
Tristan by Employee
  • 2239 Views
  • 0 comments
  • 3 kudos

Near Real Time Reporting

Introduction Incorta is not a real-time data platform, however given its unique approach that allows customers to leave data “in-shape”, paired with its speed when it comes to extracting and preparing data, it can support very frequent data refreshe...

spark.jpg
Tristan by Employee
  • 1840 Views
  • 0 comments
  • 0 kudos