How use OI procedure to add incrementals (OpenInsight Specific)
At 06 JUL 1999 11:00:02AM Weiwu Zhu wrote:
1. How to append incremental data by OI procedures?
I wanted to convert some ARev tables into SQL server tables. Firstly, I run OI procedures for full loading (all records), and then I wanted to get new data as incrementals dairy, so I run the OI procedures by 'changes only'. But I have not found any difference in the DB size and row amounts of tables after running the procedures by 'changes only'. So, how to append incremenatls at end of a table by running OI procedure, to let a database growth?
2. What means exactly when running OI warehouse procedure by 'changes only'? After this, the old data will be overwritten by the 'changes data'? Or the 'changes data' will be attached at end of a table?
How to confirm the OI procedure run appropriately?
2. When I run the OI procedures to warehouse ARev tables into SQL tables, after click 'Schedule' button, I can see three options in Record Selection: All records, Changes only, and Customer. How use the 'Customer'option?
3. When I run OI procedure, sometime I got lots of error messages such as:
07/05/99 16:54:45 COVERAGE: Error Processing 100033
But, I often got no error message by running the same procedure on the same table (COVERAGE). What is the reason for the error message?
Your help is greatly appreciated.
Weiwu