Data & Schema Discussions

sentiment analysis demo

Recently (a couple of months ago?) Incorta did a demo of sentiment analysis using British Airways customer reviews. I'd like to duplicate that to use as a sales demo as well. I have the data massaged into a materialized view, but I don't see what t...

Resolved! How to Create a Cross JOIN without using MV or Incorta SQL

Hi All,As per the company policy, we are not supposed to use Meterialized View(except Bridge table) and Incorta SQL for any data mapping logic. I have two tables INVOICE_PAYMENTS and INVOICE_DISTRIBUTIONS. The INVOICE_ID is the Join Key for these tw...

Duplicating Schemas

I am seeking advice on the least risky way to duplicate a schema.Here's the scenario: I am using a data app from Incorta. The company has two separate instances of the ERP, one in the US and one in Japan. Obviously, deploying the data app once will a...

Materialized view issue

Hello dears I have Python algorithem to solve a complicated issue and Return a new df, but I have not any experience in pyspark method, so can any one help me to excute this code at pysparkThanks

Schema Naming Convention strategy

Does anyone have any good ideas on how to name their schemas and business schemas?We have different types of schemas - some pull data in externally, but others only use Alias tables from other schemas. We have some that serve very specific purposes ...