Class LookupTransformation
The lookup transformation enriches the incoming data with data from the lookup source. Data from the lookup source is read into memory when the first record arrives. For each incoming row, the lookup tries to find a matching record in the memory table and uses this record to add additional data to the ingoing row.
Implements
IDataFlowSource<System.Dynamic.ExpandoObject>
IDataFlowDestination<System.Dynamic.ExpandoObject>
Inherited Members
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.ToString()
Namespace: ETLBox.DataFlow.Transformations
Assembly: ETLBox.dll
Syntax
public class LookupTransformation : LookupTransformation<ExpandoObject, ExpandoObject>, ILoggableTask, IDataFlowLogging, IDataFlowTransformation<ExpandoObject, ExpandoObject>, IDataFlowSource<ExpandoObject>, IDataFlowSource, IDataFlowDestination<ExpandoObject>, IDataFlowDestination, IDataFlowComponentConstructors
LookupTransformation()
Declaration
public LookupTransformation()LookupTransformation(IDataFlowExecutableSource<ExpandoObject>)
Declaration
public LookupTransformation(IDataFlowExecutableSource<ExpandoObject> lookupSource)Parameters
| Type | Name | Description |
|---|---|---|
| IDataFlowExecutableSource<System.Dynamic.ExpandoObject> | lookupSource |
LookupTransformation(IDataFlowExecutableSource<ExpandoObject>, Func<ExpandoObject, ExpandoObject>)
Declaration
public LookupTransformation(IDataFlowExecutableSource<ExpandoObject> lookupSource, Func<ExpandoObject, ExpandoObject> transformationFunc)Parameters
| Type | Name | Description |
|---|---|---|
| IDataFlowExecutableSource<System.Dynamic.ExpandoObject> | lookupSource | |
| System.Func<System.Dynamic.ExpandoObject, System.Dynamic.ExpandoObject> | transformationFunc |
LookupTransformation(IDataFlowExecutableSource<ExpandoObject>, Func<ExpandoObject, ExpandoObject>, List<ExpandoObject>)
Declaration
public LookupTransformation(IDataFlowExecutableSource<ExpandoObject> lookupSource, Func<ExpandoObject, ExpandoObject> transformationFunc, List<ExpandoObject> lookupList)Parameters
| Type | Name | Description |
|---|---|---|
| IDataFlowExecutableSource<System.Dynamic.ExpandoObject> | lookupSource | |
| System.Func<System.Dynamic.ExpandoObject, System.Dynamic.ExpandoObject> | transformationFunc | |
| System.Collections.Generic.List<System.Dynamic.ExpandoObject> | lookupList |