MDM Registry Edition
- MDM Registry Edition 10.5 HotFix 2
- All Products
CREATE_IDT IDT-Name MERGED_FROM [connection_string] merge_clause [TRANSFORM transform_clause] ... SYNC | NOSYNC ;
CREATE_IDT idt_xform_merge MERGED_FROM odb:99:scott/tiger@mars #SSA_UID#.TESTX51A.FULL_NAME NAME C(50), #SSA_UID#.TESTX51A.SSN (PK) SSN, #SSA_UID#.TESTX51A.ADDR_L1 $a1, #SSA_UID#.TESTX51A.ADDR_L2 $a2, #SSA_UID#.TESTX51A.ZIP $zipcode TRANSFORM source-id MyId c(10) order 1, concat($a1,$a2,$zipcode) ADDR c(50) order 3 MERGED_FROM odb:99:buzz/lightyear@jupiter #SSA_UID#.TESTX51B.EMPNO SSN, #SSA_UID#.TESTX51B.GIVEN $given, #SSA_UID#.TESTX51B.FAMILY $family, #SSA_UID#.TESTX51B.ADDR ADDR TRANSFORM concat($given,$family) NAME SYNC ;