Basically, delta load captures when there is any change, update, insert happens based on the Change date like CPUDT, UDATE. But when we have the ERDAT as delta filter it will just capture the new record but what will happen to the Change ? Does any one tried this or come across this senario?
Question
Dear Community Members,Have anyone of you tried applying the table using the ERDAT field in Daily Delta load. If yes have you reconsiled whether it captures the change and insert data?
+5
I've tried this before. In this case, it wouldn't capture any changed records. You would only get changes to records on the full loads. I wouldn't recommend this, but it depends on your use-case.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.