Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Do you have a unique key in the tables?
use that instead
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.
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.
What kind of incremental load do you want to do ?
a. Insert only records
or
b. Insert and Update records
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
Hi Ashish,
Second one, Insert and update records.
Rgds,
Raju.
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
kindly share some sample data to figure out the solution,
In fact I am also looking forward hearing from experts on such scenario.
Hi Raju,
How did you manage the incremental load? Could you please share us. Thank you.