data-dictionary

FPSBASE.STARTUP_COPY_NONHIST_DATA

Data Dictionary

>

FPSBASE Views

> FPSBASE.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