Previous Topic: Delta Processing RulesNext Topic: Next Snapshot for a Given MUF Execution

AutoCollect – Creating SNAPSHOT and System DELTA Rowsets › Process Snapshot Rowsets into Delta Rowsets › Delta Processing Rules › First Snapshot Rowset for a Given MUF Execution (MUFNAME and S_MUF_ENABLE)

First Snapshot Rowset for a Given MUF Execution (MUFNAME and S_MUF_ENABLE)

Create a Delta row with fixed values from the first Snapshot row since MUF was enabled.

Row

Value

D_MUF_ENABLE

from S_MUF_ENABLE

D_MUF_START_DATETIME

from S_MUF_ENABLE

D_MUF_END_DATETIME

from S_MUF_DATETIME

D_MUFTYPE

INTERVAL

D_MUF_TOTALROW

from S_MUF_TOTALROW

D_MUF_DURATION

from S_MUF_DATETIME

minus S_MUF_ ENABLE

Copy corresponding Snapshot row counter values intact to Delta row.