Oracle unique constraint

Ottawa_IWOV

Hi All -

Question for the group. We are doing a traditional replicant deploy with TeamSite 6.1 and DD 5.6

Basically we are deploying the replicant ID and another ID that is forming a composite key. Is there a way to approach this so that the replicant is the primary key, and then perform a unique constraint of some sort.

Does anyone have an example of how this would work with Data Deploy?

Thanks,

Migrateduser

I'm not sure I understand. You can use a replicant value as a PK like below with the Vector column in the Vector_List table. Usually the replicant is a unique value... but I don't think that's what you're asking about... so give some more specifics.

Mariam

<?xml version="1.0" encoding="ISO-8859-1" standalone="yes" ?>
<data-deploy-configuration>
<client>
<deployment name="basearea">
<source>
<!-- <xml-source options="wide" area="/default/main/nw0_teamsite/mv0_hr/WORKAREA/xjq5d43_workarea" area-type="ts-filesystem" xml-type="interwoven">
<path name="templatedata/database/locations/data" visit-directory="deep"/>
</xml-source>-->
<teamsite-templating-records area="/default/main/nw0_teamsite/mv0_hr/WORKAREA/xjq5d43_workarea" options="full,wide">
<path name="templatedata/database/locations/data" visit-directory="deep" />
</teamsite-templating-records>

</source>
<destinations>
<database db="mach2:1521ra816db" user="sam" password="****" vendor="oracle" update-type="standalone" state-field="state" real-update="yes" delete-tracker="yes" enforce-ri="no">

<dbschema>
<group name="medical" root-group="yes">
<attrmap>
<column name="Disease" data-type="VARCHAR(100)" value-from-field="Disease" allows-null="no" is-url="no"/>
<column name="Latin_Name" data-type="VARCHAR(100)" value-from-field="Latin Name" allows-null="no" is-url="no"/>
<column name="Type" data-type="VARCHAR(15)" value-from-field="Type" allows-null="no" is-url="no"/>
</attrmap>
<keys>
<primary-key>
<key-column name="Disease"/>
</primary-key>
</keys>
</group>
<group name="Vector_List" root-group="no">
<attrmap>
<column name="Vector" data-type="VARCHAR(40)" value-from-field="Vector List/[0-5]/Vector" is-replicant="yes" allows-null="no" is-url="no"/>
<column name="Disease" data-type="VARCHAR(100)" value-from-field="Disease" allows-null="no" is-url="no"/>
</attrmap>
<keys>
<primary-key>
<key-column name="Vector"/>
<key-column name="Disease"/>
</primary-key>
<foreign-key parent-group="medical">
<column-pair parent-column="Disease" child-column="Disease"/>
</foreign-key>
</keys>
</group>
<group name="Symptom_List" root-group="no">
<attrmap>
<column name="Symptom" data-type="VARCHAR(255)" value-from-field="Symptom List/[0-5]/Symptom" is-replicant="yes" allows-null="no" is-url="no"/>
<column name="Disease" data-type="VARCHAR(100)" value-from-field="Disease" allows-null="no" is-url="no"/>
</attrmap>
<keys>
<primary-key>
<key-column name="Symptom"/>
<key-column name="Disease"/>
</primary-key>
<foreign-key parent-group="medical">
<column-pair parent-column="Disease" child-column="Disease"/>
</foreign-key>
</keys>
</group>
<group name="Prognosis_List" root-group="no">
<attrmap>
<column name="Prognosis" data-type="VARCHAR(255)" value-from-field="Prognosis List/[0-3]/Prognosis" is-replicant="yes" allows-null="no" is-url="no"/>
<column name="Disease" data-type="VARCHAR(100)" value-from-field="Disease" allows-null="no" is-url="no"/>
</attrmap>
<keys>
<primary-key>
<key-column name="Prognosis"/>
<key-column name="Disease"/>
</primary-key>
<foreign-key parent-group="medical">
<column-pair parent-column="Disease" child-column="Disease"/>
</foreign-key>
</keys>
</group>
<group name="Treatment_List" root-group="no">
<attrmap>
<column name="Treatment" data-type="VARCHAR(255)" value-from-field="Treatment List/[0-3]/Treatment" is-replicant="yes" allows-null="no" is-url="no"/>
<column name="Disease" data-type="VARCHAR(100)" value-from-field="Disease" allows-null="no" is-url="no"/>
</attrmap>
<keys>
<primary-key>
<key-column name="Treatment"/>
<key-column name="Disease"/>
</primary-key>
<foreign-key parent-group="medical">
<column-pair parent-column="Disease" child-column="Disease"/>
</foreign-key>
</keys>
</group>
<group name="Drug_List" root-group="no">
<attrmap>
<column name="Drug" data-type="VARCHAR(255)" value-from-field="Treatment List/[0-3]/Drug List/[0-4]/Drug" is-replicant="yes" allows-null="no" is-url="no"/>
<column name="Treatment" data-type="VARCHAR(255)" value-from-field="Treatment List/[0-3]/Treatment" is-replicant="yes" allows-null="no" is-url="no"/>
<column name="Disease" data-type="VARCHAR(100)" value-from-field="Disease" allows-null="no" is-url="no"/>
</attrmap>
<keys>
<primary-key>
<key-column name="Drug"/>
<key-column name="Treatment"/>
<key-column name="Disease"/>
</primary-key>
<foreign-key parent-group="Treatment_List">
<column-pair parent-column="Treatment" child-column="Treatment"/>
<column-pair parent-column="Disease" child-column="Disease"/>
</foreign-key>
</keys>
</group>
</dbschema>


</database>
</destinations>
</deployment>
</client>
</data-deploy-configuration>