Data Dictionary
>
FPSAPP Views
> FPSAPP.WIP_WAFER_HIST_LOOP
View FPSADMIN.STARTUP_COPY_NONHIST_DATA
DWH_build.sh populates data in all tables where DML_scope is GLOBAL or SITE or CFG. This view builds a script to copy all data not already populated by DWH_build.sh which is not history or status data to prepare to start to load data. Typically this is used on the second database at a startup site after the first database which has limited history is proven to be working. Then we use DWH_build.sh to create a second database then use this to copy data and then start the load back quite a long time like three months. I considered making this a procedure but I really want to watch this step by step so I would rather have it be a view to create the script to run manually.
|
Column |
Comment |
|---|---|
|
SQL_QUERY |
|
|
N |