The Target Attributes report provides information about the target relations of a step.
Figure 73 is an example of the report.
Figure 73: Example of a Target Attributes Report
Table 39 describes the Target Attributes report.
|
Column |
Description |
|
Step |
Identifies the specific step in the compare plan. |
|
Relation |
Identifies the type of relation (Target Relation1 or Target Relation2). |
|
Name |
Identifies the name of the relation. |
|
Sorted |
Indicates whether the target relation is sorted. |
|
Cached |
Indicates whether the target relation is cached. |
|
GeogInfo |
Defines the data redistribution method used in a step: |
|
Confidence |
Specifies the confidence level for the estimated cardinality. The value in this column can be Low, High, Index join, or No. |
|
Compressed Columns |
Indicates whether the target spool can have compressed columns. |
|
Size (Estimated Rows) |
Indicates the cardinality estimate of the target spool. |
|
Spool Size (Bytes) |
Indicates the size of the spool in bytes. |