Discussions

tables Failing in with Errors

Hi,few EBS tables failing with below errors(Incremental Load). Could you please let me know the reason for failing.

Period Based Incremental Refresh

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...

SQL Server new Data Source connection Error

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...

Resolved! Help with Timeseries Forecasting Pill in Dashboard

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...

how to convert date to string

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...