Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    Using statistical variables in the Data flow to load a log table
Go
New
Search
Notify
Tools
Reply
  
Using statistical variables in the Data flow to load a log table
 Login/Join
 
Member
posted
Hi All,
I am new to Iway and I need to know some information about the statistical variables (like &ACCEPTS, &DELETD,&DUPLS). My requirement is to have a log table with columns like Source Database name, Target Database name, Source table name, target table name, No of rows inserted, No of rows rejected, No of rows deleted, No of rows updated, flow start time and end time. From the data migrator help I came to know that such statistical variables will be useful for this requirement. How to use such variable in my data flow or is there any other way to get such information. Kindly help me with the solutions to achieve this.

Thanks,
Balaji
 
Posts: 11 | Registered: November 06, 2013Reply With QuoteReport This Post
Guru
posted Hide Post
When you Submit or Schedule a DataMigrator flow the statistical variables are written to DataMigrator's statistics table ETLSTATS when the flow completes. See DataMigrator User's Guide Appendix A for details.
 
Posts: 380 | Location: New York City | Registered: May 03, 2007Reply With QuoteReport This Post
Member
posted Hide Post
Clif,

Thank you. That was really helpful.
 
Posts: 11 | Registered: November 06, 2013Reply With QuoteReport This Post
Member
posted Hide Post
Clif,

I tried recreating the log and statistical tables using the recreate option under Workspace->configuration Monitor ->Logs and traces -> DataMigrator Logs and Statistics -> Recreate.

ETLSTATS table is now created with only three columns S_REQ_Name, S_REQ_ID,S_APP_NAME.

How do I create the ETLSTATS table now with all the statistical variables?

Thanks,
Balaji
 
Posts: 11 | Registered: November 06, 2013Reply With QuoteReport This Post
Guru
posted Hide Post
It's possible that there is a etlstats.mas in your app path. Please run the command
WHENCE ETLSTATS MASTER
This will show you where the synonym you are using resides. It should be in the home\catalog directory for your release of the server.

From the menu options it looks like you are using an old version of DataMigrator. What release are you using? Please use the current production Release 7.7.05M.
 
Posts: 380 | Location: New York City | Registered: May 03, 2007Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    Using statistical variables in the Data flow to load a log table

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.