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.
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.
