Clarity

  • Private Community
 View Only
Back to discussions
Expand all | Collapse all

In which table does the Custom attribute which we create will gets created in Data Warehouse

  • 1.  In which table does the Custom attribute which we create will gets created in Data Warehouse

    Posted Jul 06, 2016 05:35 AM

    Hello Everyone,
    If we create Attribute in Investment Object it gets stored in ODF_CA_INV table after we run the Load Dataware house job , now in which Table that Attribute gets stored.



  • 2.  Re: In which table does the Custom attribute which we create will gets created in Data Warehouse
    Best Answer

    Posted Jul 06, 2016 08:36 AM

    If you ever want to know where any attribute is stored, after updating the DWH, go to the domain. If you edit the domain, then edit in designer and you can expand the tree to find your custom field .  Click on it and the table name shows there. Depending on what you created.

     

    Most Investment fields go to DWH_INV_INVESTMENT table in the DWH . Most likely, your custom field is in the DWH_INV_INVESTMENT table, as our custom project fields are in the DWH_INV_PROJECT table. Again, to be sure, find it in the domain. It is easy to find, as well as if you have ever changed labels and missed the object label (and only changed the view label),  the DWH will pull in the object label and not the view label. It is here, in the domain, where you can edit that.

     

    If you look at CA's Excel sheet that shows Advanced Reporting Domain Field Description, then it shows where all the OOTB fields go. You will see where the Investment object covers across several DWH_INV_*** tables.