Incremental Load for No Key Field

[#1]

Hello,

Is there any way to handle incremental load for a fact table which doesn't have a primary key?

Regards,

Amit

[Gysbert_Wassenaar]

No. If there's no way to uniquely identify a record it's impossible to tell if it changed.

[RedSky001]

You could make a primary key out of all the fields which make a row unique.

e.g.

Hash128([Field 1]                               & [Field 2]                               & [Field 3]                               & [Field 4) as Key

Then use the exists() function to check to see if this has already been loaded.

Then you can drop Key from the display dashboard, so not to take up necessary resources.

This will not always work, depends on how your source data is being updated.

Message was edited by: Mark Sheraton This will only work if you know that fields 1 to 4 uniquely identify a record.

[#4]

Thank you all.

@ Mohit, - rowno() ? let me think and try the possible logic.