@M.Davide Is it the table incremental?

Hi @M.Davide 

You should check the Errors view to see if the missing rows are located there.

Errors menu access explained.

Hi all,

the table is incremental, with a lot of data. When I make any change and need to deploy it, I lose any record, it’s like a truncate table. It happen randomly, but very frequently on FACT table.

The problem is not about primary key o validation rule, because there was not any change on them

@M.Davide what type of change are you making to the table? when you say you lose “any” record, do you mean all records or only some records?

@M.Davide could please let us know what change you are making to the incremental table? Thanks!

Hi @M.Davide,

Probably this is due the fact that you have to perfom a full load (after the change) instead of an incremental load. For example if you add a new field to the table the change also has effect on previously loaded rows. Therefore you have to perform a full load once after such change. After that, the table can be loaded incremental again.

See this link to see how to perfom a full load manually.

https://timextender.training/productdimension → section: WHAT IS AUTOMATIC INCREMENTAL LOAD? Subject: Just Once

Please let us know if this has solved the issue.

Kind regards,

Devin

Dear @M.Davide ,

To add to @devin.tiemens . I usually load all FULL in development. If you dont want to or it takes to long I have set up a execution package to just load that table and set the full load objects tab to the total project.

Or you can full load by going to the Review Tasks when Deploying (and Executing)
 

This works if you deploy the total project or a single table but does not work with perspectives. Watch out when trying to do this with perspectives because you will deploy (and execute) other tables as well and this might take a long time or break the project when working with more than 1 developer.

Hope this helps

= Daniel