The following table illustrates the relationship between Schema Mapping operator attributes DumpFieldsNoTrans and DumpFieldsWithTrans.
| If Attribute... | Is Set To... | And Attribute... | Is Set To... | Schema Mapping Operator Returns... |
|---|---|---|---|---|
| DumpFieldsNoTrans | Y | DumpFieldsWithTrans | N | DumpFieldsNoTrans |
| DumpFieldsNoTrans | N | DumpFieldsWithTrans | Y | DumpFieldsWithTrans |
| DumpFieldsNoTrans | Y | DumpFieldsWithTrans | Y | DumpFieldsWithTrans |
| DumpFieldsNoTrans | N | DumpFieldsWithTrans | N | no output for these attributes |
The following table illustrates the relationship between Schema Mapping operator attributes DumpRecordsNoTrans and DumpRecordsWithTrans.
| If Attribute... | Is Set To... | And Attribute... | Is Set To... | Schema Mapping Operator Returns... |
|---|---|---|---|---|
| DumpRecordsNoTrans | Y | DumpRecordsWithTrans | N | DumpRecordsNoTrans |
| DumpRecordsNoTrans | N | DumpRecordsWithTrans | Y | DumpRecordsWithTrans |
| DumpRecordsNoTrans | Y | DumpRecordsWithTrans | Y | DumpRecordsWithTrans |
| DumpRecordsNoTrans | N | DumpRecordsWithTrans | N | no output for these attributes |
The following table illustrates the relationship between the Schema Mapping operator attribute FormatFields and the “dump” attributes.
FormatFields is independent of all “dump” attributes except when FormatFields and all “dump” attributes are set to N.
| If Attribute... | Is Set To... | And Attribute... | Is Set To... | Schema Mapping Operator Returns... |
|---|---|---|---|---|
| FormatFields | Y | none | none | FormatFields |
| N | DumpRecordsNoTrans DumpRecordsWithTrans DumpFieldsNoTrans DumpFieldsWithTrans |
N | DumpFieldsNoTrans |
The following table illustrates the relationship among the Schema Mapping operator attributes RecordCount and AllRecords:
| If Attribute... | Is Set To... | And Attribute... | Is Set To... | Schema Mapping Operator Returns... |
|---|---|---|---|---|
| RecordCount | zero | AllRecords | N | 1 record |
| RecordCount | non-zero | AllRecords | N | RecordCount number |
| RecordCount | zero | AllRecords | Y | all records |
| RecordCount | non-zero | AllRecords | Y | RecordCount number |