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 ReportTable 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. |