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

Hi,I have created a Alias table and using it in my report. The Formula Columns in the base table not showing any values in my report. If I use the Base table in Report, the formula columns showing the correct values.Any idea on this issue? Is there a...

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