Incremental load by using primary key

[mastankomatla21]

Hi Team,

Good Morning!!

Could you please let us know,how can we implement incremental load without having Date field .If we can implement by using Primary key kindly show us the example script.

By using primary key can we implement following three methods in incremental load.

1.Insert

2.Insert and update

3.insert, update and delete

Regards,

Masthan

[Mauritz_SA]

Hi Masthan

That is very strange. Are you sure that you have the correct spelling of the column name and that you are loading it from your source again (and not a table in memory)? Below is a piece of a similar script (with variables instead of names) which is used in production. In your case the vJoinColumn would be Id.

INNER JOIN ($(pTable))

                    SQL

                    SELECT

                    $(vJoinColumn)

                    FROM

                    [$(pDataBase)].[dbo].[$(pTable)]

                    ;

Regards,

Mauritz

[Anuhyak1]

Hi Mastan,

Can you share the qvw file of Incremental logic that you have implemented with all the three steps.

Thanks