Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Member,
I have a query regarding incremental load. I am importing data from Sql table. In that table i have 4 to 5 composite keys. Now i need to do incremental load for that table. Is it possible to do incremental load without having primary key..If so can please tell me how to do.
Please let me know if you need anything more.
Thanks and Regards,
R. Bharat Kishore
You need a unique identifier for each row. If you don't have one available you need to create one. Otherwise there is no way to know if a record is new or not. See this blog post for example.