Datadeploy-group

System

Hi,

I have a DCR with data either for Channel Or Dealer.If there is data entered for Channel it goes to Channel table or If data entered for Dealer it goes to Dealer table but not for both.

In my configuration file how i can tell above situation
<group name="Channels" table="CONTENT_CHANNELS" root-group="no">
<attrmap>
<column name="CONTENT_ID" data-type="NUMBER" value="1" allows-null="no" is-url="no"/>
<column name="CHANNEL_CODE" data-type="VARCHAR(10)" value="C11" allows-null="no" is-url="no"/>
<column name="CREATED_DATE" data-type="DATE" data-format="MM-dd-yy" value-from-field="Expiration_Date" allows-null="no" is-url="no"/>
<column name="CREATED_USER_ID" data-type="VARCHAR(20)" value-from-field="Author" allows-null="no" is-url="no"/>

</attrmap>
<keys>
<primary-key>
<key-column name="CONTENT_ID"/>
<key-column name="CHANNEL_CODE"/>

</primary-key>

</keys>
</group>


<group name="DEALERS" table="CONTENT_DEALERS" root-group="no">
<attrmap>
<column name="CONTENT_ID" data-type="NUMBER" value="1" allows-null="no" is-url="no"/>
<column name="DEALER_CODE" data-type="VARCHAR(10)" value="D11" allows-null="no" is-url="no"/>
<column name="CREATED_DATE" data-type="DATE" data-format="MM-dd-yy" value-from-field="Expiration_Date" allows-null="no" is-url="no"/>
<column name="CREATED_USER_ID" data-type="VARCHAR(20)" value-from-field="Author" allows-null="no" is-url="no"/>

</attrmap>
<keys>
<primary-key>
<key-column name="CONTENT_ID"/>
<key-column name="DEALER_CODE"/>

</primary-key>

</keys>
</group>

I am just confused. If i entered Channel information How i can avoid dealer table.

Thanx in advance

Migrateduser

In your case if you enter just channel information, the dealer attributes would be empty and since you have dealer_code as the pri key which would be null DD will not try to insert data into the dealer table. The important issue is choosing the right keys for either tables.