Hi,I have start date (File Date) and end date in the table and i want to repeat the rows for each day from start date to end date. Is there any way that I can achieve this in MV? Please see screenshot - Appreciate your help in Advance. Thanks.
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,few EBS tables failing with below errors(Incremental Load). Could you please let me know the reason for failing.
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,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...
.svg "Partner"){kind=icon}