AnsweredAssumed Answered

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

Question asked by JayaSantoshKumar on Nov 21, 2016
Latest reply on Nov 21, 2016 by navzjoshi00

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.