Data loss during SAC Model Import

[rijin_baby]

I have a Data model in SAC, onto which I am uploading data from Datasphere using an import connection.

In datasphere there exist 738648 rows. I deleted all data present in the Model
and the import in SAC shows that 738648 rows were imported successfully (I tried both "Update" & "Add" option while importing)

BUT, On checking the model the no.of rows is lesser 679856

Can you help me identify the problem, is there anything I need to check specifically while updating data to a SAC model.

Thank You

[N1kh1l · Accepted solution]

rijin_baby

You may be loading 1000 records for e.g. from source but any duplicate records in terms of same master data for all columns  will get aggregated or overwritten there by resulting in record suppression in model. Please check for 1 period in source if all your column values in datasource have unique master data for all records.

Hope this helps !!

Br.

Nikihl

[rijin_baby · Accepted solution]

Thank you Nikhil, The error was with the primary key setting in the consumption model in Datasphere