Hi Team,Can anyone explain how to do period-based Incremental load based on the Ship_Date column(Date format. not timestamp)?In our current ETl tool, we delete the last 3 months(Ship_Date) records from the Data Warehouse table and load the last 3 mon...
Hi Team,I'm new to Incorta and started to learn this wonderful tool.I'm trying to create an SQL Server Data Source connection in my Trail version environment but getting the below error while testing the connection.ErrorINC_03070502: Failed to Connec...
Hi All, I am looking to understand how to use the Time Series Forecasting Pill within a dashboard per this Incorta Youtube demonstration: https://www.youtube.com/watch?v=DpRfx-pjzuA I am using demo data that looks like thisWhen i attempt to add the P...
Hi,I have two columns , one is timestamp and another one is string. I want to join these two columns in spark sql mv.Date_effective column is timestamp with "yyyy-mm-dd hh:mm:ss" format.Period_name column is string with "mm-yy" format. I want write b...
Hi, I would like to load a schema only at the end of the month, but Incorta does not offer the ability to schedule it for that time.Example : We may have 28, 29, 30, or 31 days this month. With Incorta, we can schedule on a specific day instead of st...
.png "Community Manager"){kind=icon}
.svg "Captain"){kind=icon}
