Import Manager Advanced Features
I want to discuss MDM Import Manager Advanced Features.
Cloning Fields: If we want to map a source field to 2 destination fileds, we will create a clone of the source field in Import Manager and map it to 2 different destination.
This can be done only if the source type is updateable.
Adding Fields: We can add to the source data an empty field with the single NULL value in its list of distinct values. For example, if the source data is missing a field for which all of the values would be the same, you can add a field, and then use the Map Fields/Values tab to map the single NULL value to the corresponding destination value.
Renaming field: All fields can be renamed, but usually it is preferable to keep the original name.
Joining a Table: A join combines information from the records in which two tables by using the values in a pair of matching fields to match records in the two tables.
Properties of Join: Transitive Joins: If Table A is joined to Table B and Table B is joined to Table C, then Table C is effectively joined to Table A.
Primary Matching Field: The matching field in the primary table. [Join] appended to the name of the primary matching field. Also added as the first child of the lookup matching field as [From: primary table, primary matching field]
Lookup Matching Field: The matching field in the lookup table. [join] appended to the name of the lookup matching field. Also added as the first child of the primary matching field as [From: lookup table, lookup matching field]
Lookup Field: Field looked up from the lookup table into the primary table. Added as child of the lookup table into the primary table.
Looking Up a Field: Pre-requisite: A Join relationship has been established between a primary and lookup table.
MDM Import Manager added a child node at the end of the primary table.
Create Look Up Fields: At system created Child node--> right mouse click & select "Lookup" --> choose field to be looked up --> repeat as necessary.
Parametric Import: Parametric Import lists the complete set of distinct values for each field in the source data. Changing a value as part of the import (by mapping or converting it) changes it in all of the underlying records that contain that value.
Value Conversion Filter (VCF) : Value Conversion Filters automate repetitive and error- prone transformations, eliminating manual typing and the possibility of user error.
The filters can be applied at:
> Conversions are applied sequentially to each converted value that has not been individually edited or converted at the value level.
> Conversion starts with the original value.
Value level. The conversion is applied to the individual converted values.
Converted values result from:
> prior application of field-level filters.
> value-level filters.
> manual edits.
For each field, you can apply one or more value conversion filters at the field level. For each value, you can apply one or more value conversion filters at the individual value level(reagrdless of whether or not value mapping is required).
There is an option for Multiple-Step VCFs.
For example when we apply: "Apply Operator [Prepend "Before TEXT]"
Where to set the Operator?
I am also clear with Value Field Partition Concept.
When you want to apply an operator to the converted source value.
- Select the Value in the Value mapping
- Rt Click- > Apply Operator
- It will by default take the selected value as the Operand 1
- Then you need to select whether you want to append or prepend the Operator
- Your operand 2 will be the operator you wish to prepend or append say(#) for eg
- So it will append or prepend # to your selected value.
Hope It Helped
Thanks & Regards