Andersson HDB 1.0 Manual de usuario descargar pdf (Pagina 9)

When the job is run and DA compares a DATE with a VARCHAR, DA uses the FORMAT to parse the VARCHAR

value to a DATE prior to performing the comparison.

The Comparison FORMAT_DATE can be used in a similar way:

create job job2

add comparison cmpson2

set compareset cs1

and set format_date ‘yyyy MMM dd’

Both techniques have advantages and disadvantages:

● The Comparison FORMAT_DATE option is easier to configure and will apply to all columns that require

VARCHAR to DATE conversions. However, because it is generic it cannot be applied during hashing and

sorting. This is suitable for LITERAL comparisons of non-key column values only.

● The Column FORMAT option must be applied to each column that requires it (more configurations

required). However, because it is specific to a column it works well with hashing and sorting. Use this when

the Comparison FORMAT_DATE is not appropriate.

1.2 Support for Scale Rounding at the Comparison and

Column Levels

In SAP Replication Server Data Assurance Option (SAP DA) version 15.7.1 SP204, all scale values are now at

the COMPARISON and/or COLUMN level.

The new COMPARISON SCALE option sets the scale value. SAP DA uses this value when comparing two

floating point numbers. You can override this at the column level by setting the new COLUMN SCALE option.

From version SP204, SAP DA no longer supports the COMPARER_SCALE_ROUNDING parameter. If you do

not explicitly set a COMPARISON SCALE when you create a job, DA automatically sets COMPARISON SCALE

to the value of the new configuration property DEFAULT_COMPARISON_SCALE.

Note

You can change the COMPARISON SCALE and COLUMN SCALE at any time using the ALTER JOB

command.

1.3 Run Data Assurance as a Windows Service

Configure an SAP Replication Server Data Assurance server or agent to run as a service in 64-bit Windows.

Once the Windows service is configured, you can start, stop, troubleshoot, or remove it.

New Features Guide

New Features in SAP Replication Server Data Assurance 15.7.1 SP204

P U B L I C

1 2 3 4 5 6 7 8 9 10 11 12 13 14 ... 43 44

Sin comentarios

Andersson HDB 1.0 Manual de usuario Pagina 9