But when I am passing only delta to the staging server then I am not able to build the history. Because checksum in sqlserver and hashfunction in oracle cannot be compared. Henced I have to dump everything onto staging and calculate the delta.
Now client is not approving this approach.
They wants delta to come from server A. But problem with this approach is history building. Example table1 in server A has values 1, 2, 3. And table2 has value 1, 2. Henced by the end of pass 1 delta is 3. Now when I am running the package for 2nd time then delta 3 should be appended to table2 otherwise we will always get cumulative delta.
Since server A is an oracle application ie legacy system, I have only select rights. I dont have access for creation or insertion.