Incremental Load with out Audit columns

[Anonymous]

Hi Experts,

My Masters and dimension tables doesn't have audit columns (Created on , updated on), How to i place incremental load???

Your help is much appreciated.

Thanks & Regards,

Raju Kuppusamy

[giakoum]

Do you have a unique key in the tables?

use that instead

[#3]

Hi,

Im not sure but In your case you can use row id as a unique no .

you will get an a unique Combination of record.

[#4]

1. If  table has primary key, use like where not exists(primary key column)

2. If table does not have primary key,  create composite key by concatenating two or more columns to create unique record.

Please share sample data  if you are not getting still.

Thanks,

Uday.

[#5]

What kind of incremental load do you want to do ?

a. Insert only records

or

b. Insert and Update records

[avinashelite]

Hi Raju,

If you don't have the date columns then try to implement it by the key values i.e check whether the key value exist or not based on this you can implement the incremental load

[Anonymous]

Hi Ashish,

Second one, Insert and update records.

Rgds,

Raju.

[Anonymous]

Thanks a lot Avinash,

But my data's are keep getting updated in back end. I need to find only updated invoices to do the incremental load.

Help me..

Thanks & Regards,

Raju Kuppusamy

[#9]

kindly share some sample data to figure out the solution,

In fact I am also looking forward hearing from experts on such scenario.

[qlikviewwizard]

Hi Raju,

How did you manage the incremental load? Could you please share us. Thank you.