[Home] [Help]
62:
63: -- Step 4. update PROJECT_ORG_FK in the fact staging table
64: -- with Task Owning Organization from the Task Level table
65:
66: update fii_pa_cost_fstg fstg
67: set project_org_fk =
68: (
69: select denorm_task_org_fk
70: from edw_proj_task_ltc task
79: -- table by Project Dimension collection process between Steps 3 and 4.
80: -- Step 5 guarantees that FSTG and F tables are always in sync in
81: -- respect to the LTC tables.
82:
83: update fii_pa_cost_fstg fstg
84: set project_org_fk =
85: (
86: select attribute3
87: from fii_system_event_log log