Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to fetch the updated data from the database though there exists the historical data in the same table?
I dont have date field in that so how to fetch?
ya but i dont have time stamp to do that? so how can i?
By using the incremental load or direct connect the database reload the data than get the total data
hi vsudhakar..... can you be clear at what u r saying
thanks
i have a doubt that incremental load data can only be used for insert , update and delete but these can be done with the data only wen we are going to add....... but what about the data where already it is there with historical dat a. for example the primary key is 101 and city has been changed from city1 to city2 now i need the changed city name..... here i dnt have any date field. and this i am doing in excel sheet and not using any databases..... this is the scenario i am asking for. Pls can anyone help me ?
how can you determine what has been created, updated or deleted? Usually this would be a unique Id and a modified date.