Audit Log – Load Table

Code Banner

Loads the time taken to load the table along with the size

 

 

/*************************************************************************************************/

 

/**********Update start for audit log***********/
LET vAuditLog_Start = TimeStamp(Now());
/***********************************************/
FACT_Table:
Load * from
[C:FACT_FILE.qvd] (qvd);

 

 

// Store the table size & Duration in audit log
/***************Update audit log****************/
LET vTable = ‘FACT_Table’; LET vRows  = NoOfRows(‘$(vTable)’);  LET vFields = NoOfFields(‘$(vTable)’);
CALL AuditLog (‘$(vCycleStart)’,’$(vAuditLog_Application)’,’QVD FACT Row Count’,’$(vTable)’,’$(vRows)’,’$(vAuditLog_Start)’);
CALL AuditLog (‘$(vCycleStart)’,’$(vAuditLog_Application)’,’QVD FACT Field Count’,’$(vTable)’,’$(vFields)’,’$(vAuditLog_Start)’);
CALL AuditLog (‘$(vCycleStart)’,’$(vAuditLog_Application)’,’Duration’,’$(vTable)’,”,’$(vAuditLog_Start)’);
LET vTable =; LET vRows  = ;  LET vFields = ;
/***********************************************/
/***************Update audit log****************/
CALL AuditLog (‘$(vCycleStart)’,’$(vAuditLog_Application)’,’Duration’,’FACT_Table’,”,’$(vAuditLog_Start)’);
/***********************************************/

One response to “Audit Log – Load Table

  1. Pingback: Audit Logging | qlikcentral·

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s