This discussion is archived
1 Reply Latest reply: Jul 3, 2012 12:19 AM by priyanshu gupta RSS

Staging table for PDH

929896 Newbie
Currently Being Moderated
Hi,
Anyone please tell me what are the staging tables for PDH.
Actually I am using ODI to put data from eBS to PDH.
So where I will put the data.
How this can be achieved.

Thanks
  • 1. Re: Staging table for PDH
    priyanshu gupta Newbie
    Currently Being Moderated
    Some of the staging tables are:

    1) Items -- mtl_system_items_interface
    2) Item Categories -- mtl_item_categories_interface
    3) Cross Reference -- MTL_CROSS_REFERENCES_INTERFACE
    4) Item Revision Interface -- MTL_ITEM_REVISIONS_INTERFACE
    5) Item Relation Interface -- MTL_RELATED_ITEMS_INTERFACE
    6) Item Catalog Group Interface -- MTL_ITEM_CAT_GRPS_INTERFACE
    7) Attribute Group Interface -- EGO_ATTR_GROUPS_INTERFACE
    8) Item UDA Interface -- EGO_ITM_USR_ATTR_INTRFC
    9) EGO_ITEM_ASSOCIATIONS_INTF
    10) EGO_ITEM_PEOPLE_INTF

    There are some more you can get all that by querying the database.

    Hope it helps.

    Thanks,
    Priyanshu

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points