Clarity

  • Private Community
Back to discussions
Expand all | Collapse all

Which table stores records of Project and Program which has no Hierarchy

  • 1.  Which table stores records of Project and Program which has no Hierarchy

    Posted Nov 21, 2016 08:42 AM

    Hello All,
    We have DWH_INV_HIERARCHY table in DWH where it stores Child_investment and Parent_investment_key , but when a Project/Program has no Childs in it then this table dosen't store ,
    In Inv_Hierarchies table it stores Parent,Child records information keeping null in the Parent column when Project/Program has no Records, Now in DWH which table exactly replicates the Inv_hierarchies.

    Regards,
    Santosh.



  • 2.  Re: Which table stores records of Project and Program which has no Hierarchy

    Posted Nov 21, 2016 09:14 AM

    If there is no record in the table that would mean that there is no hierarchy

     

    NJ