Document toolboxDocument toolbox

Does S2PX support conversion of Hashed File's nested sub-records?

Hashed Files support the concept of records within records (i.e nested sub-records). Relational databases don't. How does S2PX we deal with that pattern?

Sub-records in Server are just strings with special handling of the @FM, @VM, @SM , etc marks.  These strings can be written/read from the DRS Connector without any issue.  Other than supplying custom SQL to read from specific fields/sub-fields there is no option to handle sub-record data individually within the Hashed File stage. The S2PX replacement implementation, therefore, doesn't need any additional capabilities for sub-records.

© 2015-2024 Data Migrators Pty Ltd.