load a table without unique indentifier

Hi i got a doubt.

i try to load a table to a staging area.

so my problem is that that table doesnt have a primary key if i try to create one put together fields to get a unique identifier i cant either. so i need an advice to know how load that table in order to make incrementals load of it .

thanks

Why do you need a primary key?

Hi thanks for answer.

i need a primary key in order to make a incremental load. i work in sql server. so to do incremental load i use the lookup control and it need at least one column to compare the row and determine if the row if already load.

to find out if the row exist i can compare all columns. but is complicated when i try to find the updates load.

or maybe can make it in other way ....

thanks

You answered your own question.

If you have nothing from which you can identify two things to compare, you can't very well compare them. This is true in databases and life in general...

You may need to rethink your source or how you load the DW.

Hi yes you right i guess i complicated myseft. now i rethink the problem and figure it out that joining that table whith other (s) i find some kind of relation
thanks your tour time I really appreciate your support

Create a check sum based on all of the columns.

Hi mm but maybe im wrong in that case any change in one row its gonna be identified as a new row?

You should try to identify a compound primary key--some combination of fields that uniquely identifies a row. Once you can uniquely identify a row, then you can do inserts or updates as needed.

If your incoming data really doesn't have a key--that is, you might get multiple records with the exact same values in every field, and these records represent different events/occurrences--then it is impossible to do updates; you would need to treat each new occurrence of a record as an insert.

Hi yes i really try to fing a compound primary key but is dificult and i allready thought about threat each occurrence like a new record but i guess is not secure because the table i try to load is about Historical payments. i allready try to valide by dates like.

i run de load today but before delete all records of today. im thinking about it.........