Deletes followed by inserts only for Childs?

System

Hi,

We have a requirement for managing certain colums in parent table with a sql script that runs nightly and all other columns with dd tool. New record creation will be done by dd tool. I never came across this kind of requirement before. Is this dovable?

As per dd admin guide, it says datadeploy default behavior is "deletes followed by inserts" If referential integrity is being enforced. But as per dd logs, this behavior is true only for child tables.

Here is dd log snippet, where Document is the parent table group, document_product and document_state are child table groups. I am little bit confused on what is mentioned in guide vs what I see in the logs. Can someone clarify on this please? Appreciated.

Filelist walk done
Stat for group [Document]:
-----------------------------------
Rows inserted : 0
Rows updated : 7
Rows deleted : 0
Rows failed : 0
Rows rolled back : 0
Rows skipped : 0
-----------------------------------
Stat for group [Document_Product]:
-----------------------------------
Rows inserted : 7
Rows updated : 0
Rows deleted : 7
Rows failed : 0
Rows rolled back : 0
Rows skipped : 0
-----------------------------------
Stat for group [Document_State]:
-----------------------------------
Rows inserted : 90
Rows updated : 0
Rows deleted : 90
Rows failed : 0
Rows rolled back : 0
Rows skipped : 0
-----------------------------------
Committing database [XYZSQLP1301:?database=XYZ_Web]...
Deployment[DocMetadata]
-----------------------------------
DCRs inserted : 0
DCRs updated : 7
DCRs deleted : 0
DCRs failed : 0
DCRs rolled back : 0
DCRs skipped : 0
-----------------------------------
Started : Tue Mar 29 12:56:40 CST 2005
Finished: Tue Mar 29 12:56:46 CST 2005

### IWDataDeploy DONE ###


Thanks,
Krishna.