Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
1 reply Latest Post - ‏2012-09-28T07:23:51Z by Sadagopan_Krishnamachari
Sadagopan_Krishnamachari
14 Posts
ACCEPTED ANSWER

Pinned topic Product Domain - Admin_Product_Id in both PartyProductRole&ProductEquiv

‏2012-06-14T16:12:30Z |
Hello All,

I would like to understand what's the reason for having the Product_Id, Cont_Id, Admin_Product_Id and Admin_Client_Id the ProductPartyRole table. If this table is used to establish the product to party relationship wouldn't it be sufficient to store the PRODUCT_EQUIV_ID( primary key of the ProductEquiv table ( thereby indirectly linking the PRODUCT_ID) ) and the CONT_EQUIV_ID ( Primary key of the ContEquiv table (thereby indirectly linking the CONT_ID) ? Are Admin_Product_Id and Admin_Client_Id added just to facilitate search?

Also why is Admin_Sys_Tp_Cd required in the ProductPartyRole table? what does it signify?

thanks & regards
Updated on 2012-09-28T07:23:51Z at 2012-09-28T07:23:51Z by Sadagopan_Krishnamachari
  • Sadagopan_Krishnamachari
    14 Posts
    ACCEPTED ANSWER

    Re: Product Domain - Admin_Product_Id in both PartyProductRole&ProductEquiv

    ‏2012-09-28T07:23:51Z  in response to Sadagopan_Krishnamachari
    I believe this provides the flexibility when the customer does not have one of the domains. So it could be possible that party domain has been used by the customer and hence there is no need of the Product model of MDM.