Class AstSlowlyChangingDimensionNode
The Slowly Changing Dimension transformation checks for dimension attribute changes in incoming data, determines how related records are updated, and specifies how the updated records are inserted into data warehouse dimension tables.
public class AstSlowlyChangingDimensionNode : AstSingleInTransformationNode, IBindableItem, IVulcanCollectionParent, IVulcanNotifyPropertyChanged, IPropertyChangeNotificationTarget, IGetJsonProvider, INamedNode, IScopeBoundary, IReferenceableItem, IFrameworkItem, INotifyPropertyChanged, IXObjectMappingProvider, IValidationInfo, IDataErrorInfo, INamedItem, IScopedNameIndexable, IDataflowItem
- Inheritance
-
System.ObjectAstSlowlyChangingDimensionNode
- Derived
-
AstSlowlyChangingDimensionNode
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
| AstSlowlyChangingDimensionNode(IFrameworkItem) | Initializes a new instance of the AstSlowlyChangingDimensionNode class with the specified parent node. |
Properties
| ChangingAttributePath | Gets the changing attribute output path for this transformation |
| Columns | This is a collection of column mapping definitions that determine how each of the specified columns will be handled with respect to value changes. |
| Connection | This value specifies a direct reference to the OLE DB connection where the query will be executed. |
| CurrentRowWhere | This WHERE clause specifies only the current row when several rows have the same business key. |
| CurrentRowWhereDefaultValue | Gets the default value for the CurrentRowWhere property |
| DefaultCodePage | This value specifies which default code page to use when the data source does not specify a default code page. |
| DefaultCodePageDefaultValue | Gets the default value for the DefaultCodePage property |
| EnableInferredMember | This value determines whether the Slowly Changing Dimension transformation will check for inferred member records that require updating. |
| EnableInferredMemberDefaultValue | Gets the default value for the EnableInferredMember property |
| FailOnFixedAttributeChange | This value indicates whether the transformation fails when changes occur in row columns with Fixed attributes. The default value is False. |
| FailOnFixedAttributeChangeDefaultValue | Gets the default value for the FailOnFixedAttributeChange property |
| FailOnLookupFailure | The value determines whether the transformation fails if no match for an incoming row is found in the lookup table. The default value is False. |
| FailOnLookupFailureDefaultValue | Gets the default value for the FailOnLookupFailure property |
| FixedAttributePath | Gets the fixed attribute 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 |
| HistoricalAttributePath | Gets the historical attribute output path for this transformation |
| IncomingRowChangeType | This value determines whether incoming rows are handled as new rows, or whether the type of change is detected for each column and the incoming rows directed to output based on types of changes they contain. |
| IncomingRowChangeTypeDefaultValue | Gets the default value for the IncomingRowChangeType property |
| InferredMemberIndicator | This value specifies the name of the column which is used to store inferred member records. |
| InferredMemberIndicatorDefaultValue | Gets the default value for the InferredMemberIndicator property |
| InferredMemberPath | Gets the inferred member output path for this transformation |
| NewPath | Gets the new output path for this transformation. This is the preferred output path and will automatically connect to any single-input transformation nodes that directly follow it in the Biml file. |
| Query | This value specifies the text or location of the query that will be executed. |
| UnchangedPath | Gets the unchanged output path for this transformation |
| UpdateChangingAttributeHistory | This value specifies whether or not historical attribute changes sent to the output path for changing attribute updates. |
| UpdateChangingAttributeHistoryDefaultValue | Gets the default value for the UpdateChangingAttributeHistory 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. |