Class AstOracleDestinationNode
The Oracle Destination loads data into an Oracle database that uses a database table, a view, or an SQL command. This is done specifically using the Attunity Oracle Connector.
public class AstOracleDestinationNode : AstDestinationTransformationNode, IBindableItem, IVulcanCollectionParent, IVulcanNotifyPropertyChanged, IPropertyChangeNotificationTarget, IGetJsonProvider, INamedNode, IScopeBoundary, IReferenceableItem, IFrameworkItem, INotifyPropertyChanged, IXObjectMappingProvider, IValidationInfo, IDataErrorInfo, INamedItem, IScopedNameIndexable, IDataflowItem
- Inheritance
-
System.ObjectAstOracleDestinationNode
- Derived
-
AstOracleDestinationNode
IBindableItem, Varigence.Utility.Collections.IVulcanCollectionParent, Varigence.Utility.ComponentModel.IVulcanNotifyPropertyChanged, Varigence.Utility.ComponentModel.IPropertyChangeNotificationTarget, IGetJsonProvider, INamedNode, IScopeBoundary, IReferenceableItem, IFrameworkItem, System.ComponentModel.INotifyPropertyChanged, Varigence.Utility.Xml.IXObjectMappingProvider, IValidationInfo, System.ComponentModel.IDataErrorInfo, INamedItem, Varigence.Utility.Collections.IScopedNameIndexable, IDataflowItem,
Constructors
| AstOracleDestinationNode(IFrameworkItem) | Initializes a new instance of the AstOracleDestinationNode class with the specified parent node. |
Properties
| BatchSize | This value specifies how many rows can be loaded into the destination table in each batch before additional rows are requested from the data flow pipeline. The default value is 100. |
| BatchSizeDefaultValue | Gets the default value for the BatchSize property |
| Columns | This value specifies how the component should map columns in the data flow to columns in the destination. Columns that are not explicitly listed in this collection are automatically mapped based on name. |
| Connection | This value specifies the Oracle connection to use when loading the data. |
| DefaultCodePage | This value specifies which code page to use when the data source does not provide code page information. |
| DefaultCodePageDefaultValue | Gets the default value for the DefaultCodePage property |
| Destination | This value specifies the location to which the data is written. |
| ErrorOutput | Gets the error output path for this transformation |
| FriendlyTypeName | Gets the friendly name of the type of this node |
| FriendlyTypeNameStatic | Gets the friendly name of the type of this node |
| LobChunkSize | This value specifies the chunk size that should be allocated of Large Object (LOB) columns. |
| LobChunkSizeDefaultValue | Gets the default value for the LobChunkSize property |
| MaximumErrorCount | This value specifies the maximum number of errors that may be encountered before the component execution fails. |
| MaximumErrorCountDefaultValue | Gets the default value for the MaximumErrorCount property |
| TransactionSize | This value specifies how many rows can be added in a single transaction before a new transaction must created on the Oracle server. The default value is 100. |
| TransactionSizeDefaultValue | Gets the default value for the TransactionSize property |
| TransferBufferSize | This value specifies the size in kilobytes (KB) of the memory buffer that is used to transfer data to the Oracle server. The default value is 64. |
| TransferBufferSizeDefaultValue | Gets the default value for the TransferBufferSize property |
| UseFastLoadIfAvailable | This value specifies whether Oracle conventional bulk load options are used. |
| UseFastLoadIfAvailableDefaultValue | Gets the default value for the UseFastLoadIfAvailable property |
| UseNoLogging | This value specifies whether target table logging should be disabled. Logging is typically disabled to reduce the quantity of redo metadata that is generated on the server. |
| UseNoLoggingDefaultValue | Gets the default value for the UseNoLogging property |
| UseParallelLoad | When set to true, this value indicates that the data can be loaded into the Oracle target table via multiple parallel data transfers. |
| UseParallelLoadDefaultValue | Gets the default value for the UseParallelLoad property |
Methods
| BindingScopeBoundaries() | Retrieves the permitted scope boundaries to bind references from this node. |
| BindReference(SymbolTable, String, Boolean, String, Int32, Boolean) | |
| CopyFrom(IFrameworkItem, UnboundReferences) | Instructs the node to copy property values from the supplied node into itself. This method should only be used by the internal Biml framework. |
| DefinedAstNodes() | Retrieves a collection of nodes that have been defined as direct children of the current node. |
| Duplicate() | Creates a duplicate of the current node |
| Duplicate(Dictionary<IFrameworkItem, IFrameworkItem>) | Creates a duplicate of the current node with the scoped node mapping |
| Duplicate(IFrameworkItem) | Creates a duplicate of the current node with the specified parent item |
| Duplicate(IFrameworkItem, Dictionary<IFrameworkItem, IFrameworkItem>) | Creates a duplicate of the current node with the specified parent item and scoped node mapping |
| DuplicateHusk(IFrameworkItem) | Creates an empty object into which the values from the current node will be duplicated. This method should only be used by the internal Biml framework |
| DuplicateInto(IFrameworkItem, Dictionary<IFrameworkItem, IFrameworkItem>) | Copies the values from the current node into a husk object with the specified scoped node mapping. This method should only be used by the internal Biml framework |
| EmitXmlForAction(AstEnginePropertyAction) | Instructs the node to make changes to its underlying Biml code that correspond to the provided action. This method should only be used by the internal Biml framework. |
| EmitXmlForProperty(String, Int32) | Instructs the node to make changes to its underlying Biml code that correspond to the provided property and index. This method should only be used by the internal Biml framework. |
| ForceNull(String, Int32) | Internal method used by the compiler to make a propert value null when required by the binding framework. |
| GetAllItemsReferencedByDefinedSuccessors() | Builds a list of all items referenced by this node and its successors. Each tuple in the returned list represents a FrameworkItemReference. The first item is the ReferencingItem, the second item is the property name, and the third item is the ReferencedItem. |
| GetBimlAttributeFragment(CulturedStringBuilder) | |
| GetBimlChildFragment(CulturedStringBuilder, Int32) | |
| GetBimlFragment(CulturedStringBuilder, Int32, Boolean) | Internal method used by the Biml engine to produce the XML code for the current object. |
| GetDefaultValue(String) | Retrieves the default value for the property with the name propertyName |
| GetDefaultValue<T>(String) | Retrieves the default value for the property with the name propertyName |
| GetJson(StringBuilder, ref Boolean, Boolean, Boolean, Boolean, Boolean, Boolean, Boolean, Boolean) | Generates a JavaScript Object Notation (JSON) representation of the current node |
| GetOfflineSchemaItemResource() | |
| GetPotentialParentProperties() | Retrieves the reflection information for related properties of this node type. |
| GetPropertyValue(String) | Retrieves the current value for the property with the name propertyName |
| GetReflectionInfoFromXmlParsePath(String) | Retrieves the reflection information corresponding to the Xml parse path beginning at this node. |
| HasAnyBimlChildNodes() | |
| MergeFrom(IFrameworkItem, UnboundReferences, Boolean) | Instructs the node to merge property values from the supplied node into itself. This method should only be used by the internal Biml framework. |
| NotifyCollectionPropertyChanged(Object, String, NotifyCollectionChangedEventArgs) | Internal Biml framework method used to notify this node that the specified collection property value has changed. |
| ParseAttribute(XAttribute, ParserContext) | |
| ParseChild(XElement, ParserContext) | |
| StructureEquals(Object) | Compares this node to the provided object to determine if all defined children and references are equal. |
| Validate(ValidationReporter) | Retrieves a collection of validation and diagnostic messages for the current node. |