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.