I have a transformation inside a job, in DIS, which uses a table to create a new table with a new field which is the concatenation of two fields from the source table.
Example:
Source table:
....
Postal Code (Postal_Code) 2775-001
Postal Code Name (Postal_Code_Name) PAREDE
Target:
.....
Postal Code (Postal_Code) 2775-001
Postal Code Name (Postal_Code_Name) PAREDE
Postal Code Description (Postal_Code_Desc) 2775-001 PAREDE (New field)
How extract, from metadata, this relationship?
I intended to get the following relationships for fields
Src (Postal_Code) -> Tgt (Postal_code)
Src(Postal_Code_Name) -> Tgt(Postal_Code_Name)
Src (Postal_Code) -> Tgt (Postal_Code_Desc)
Src (Postal_Code_Name) -> Tgt (Postal_Code_Desc)
where Src means Source and Tgt menas Target.
... View more