I'm new to Data warehouse side and dont know which table actually has Data about Lookups which we create.Could you please tell me which Table stores Lookup's data and its Table relation with DWH_INV_INVESTMENT.
Look for tables with name starting with DWH_LKP_
Example, if you are looking for Investment's Progress, then join PROGRESS_KEY of DWH_INV_INVESTMENT with PROGRESS_KEY of DWH_LKP_PROGRESS
I got to know the DWH tables, when we create a Lookup with ID Test_lookup1 and we run the job "Load Datawarehouse" then its DWH Table name would be DWH_LKP_Test_lookup1 .
Retrieving data ...