incremental load using mapping variable

[dbatlanta]

Hi All,

I want to use mapping variable to do incremental load. The prob is my source doesn't have any date columns.

I tried putting sessstarttime as loadtime and used a lookup to look for the sessstartime and load new data based on it. But this logic is not working.

Basically I want to implement incremental load. And also I don't have any primary key on my source.

Thank you all in advance.

 

[blom0344]

How would you implement incremental load if you cannot bias the sessstarttime of your load against against a date or timestamp in your source?
Without such a field it is impossible to perform a check which records have already been loaded...

Does your source have a pseudo-key like a sequence-field?

Ties Blom