If you have a view that are based around a very large fact table, sometimes it would be ideal, to only add the incremental values.
It is a two step process. First you create your view based on a incremental table and then you pull that into a DWH or DSA table that is also running incremental load.
You will set up the script like this.
CREATE VIEW [NAV].[GL Entry Incr] AS
WITH CTE AS (
FROM [G/L Entry] AS A
WHERE timestamp > (
SELECT timestamp FROM [G/L Entry_INCR] AS I WHERE A.DW_Account = I.DW_Account
[Document Type Description],
[G/L Account No.],
[Posting Date Only],
[Dimension Set ID],
I use the With CTE part to create a statement that only gives me lines, where the timestamp is bigger, than the timestamp in the INCR table. The INCR table contains the highest timestamp, from the previous execution. Then I use what was extracted from that in the query below.
The next step is to pull the view in to a DWH, or similar and use that in another incremental load table.
Remember to pull in the DW_TimeStamp field from the view and use it as the incremental selection rule.