Identity Resolution
- Identity Resolution 10.5
- All Products
CREATE_IDT IDT-Name SOURCED_FROM [connection_string] source_clause [TRANSFORM transform_clause] [SELECT_BY select_clause] sync_clause ;
Source-Id Insert-Constant ("text") Upper (vf)Lower (vf) Insert-Field (vf, offset, ...) Convert-Field(<Source Field>, <Date Format>) <Target Field> C(<Length in Bytes>) Convert-Field(<Source Field>, <Encoding Format>) <Target Field> C(<Length in Bytes>) Append ( vf | lower (vf) | upper (vf) | "text" , ... ) Concat ( vf | lower (vf) | upper (vf) | "text" , ... )
convert-field($date, 2) DOB C(10)
Use the following format to convert from UTF-16 to UTF-8:create_idt IDT547 sourced_from #SSA_DBNAME# #SSA_SCHEMA#.table.PolicyHolderName $field1, #SSA_SCHEMA#.table.Gender $field2, #SSA_SCHEMA#.table.Address $field3, #SSA_SCHEMA#.table.PolicyID (PK1), #SSA_SCHEMA#.table.PINCODE $field4
TRANSFORM convert-field($field1, 8) PolicyHolderName C(20), convert-field($field2, 8) Gender C(6), convert-field($field3, 8) Address C(50), convert-field($field4, 8) PINCODE C(10)
CREATE_IDT test-idt SOURCED_FROM odb:99:scott/tiger@oracle8.17 SCOTT.EMP.EMPNO (PK) EmpNo, SCOTT.EMP.ENAME EmployeeName SELECT_BY (scott.emp.empno > 7800) SYNC ;
CREATE_IDT IDT264 SOURCED_FROM flat_file (pk) RowId W(16), $FirstName W(50), $MiddleName W(50), $LastName W(50) TRANSFORM concat (upper ($LastName), $MiddleName, $FirstName) Name W(150), SYNC REPLACE_DUPLICATE_PK TXN-SOURCE NSA ;