MAP TEST.ABC, TARGET TEST.ABC, FILTER (REGION, 'SOUTH')) ĬOLMAP (CNT = ('STATS', 'TABLE', 'ABC', (,, ' statistic') MAP TEST.ABC, TARGET TEST.ABC, FILTER (REGION, 'NORTH')) MAP TEST.ABC, TARGET TEST.ABC, FILTER (REGION, 'EAST')) MAP TEST.ABC, TARGET TEST.ABC, FILTER (REGION, 'WEST')) For example, if Replicat filters 20 rows for REGION 'WEST,' 10 rows for REGION 'EAST,' 5 rows for REGION 'NORTH,' and 2 rows for REGION 'SOUTH' (all for table ABC) the result of the is 37. In the case of an Extract that writes a source table multiple times to a single output trail, or in the case of a Replicat that has multiple MAP statements for the same TARGET table, the statistics results are based on all matching TARGET entries. TABLE EMI, TOKENS (TOKEN-CNT = ('STATS', 'TABLE', 'ABC', 'DML')) For example, if Extract captures 100 inserts for table ABC and writes table ABC to three trails, the result for the is 300 Understanding How Recurring Table Specifications Affect Operation CountsĪn Extract that is processing the same source table to multiple output trails returns statistics based on each localized output trail to which the table linked to is written.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |