Top Node Indicator and Multi Character Delimiters for Extracts and Loads
Viewpoint extracts and loads provide additional options to customize how hierarchy top nodes get identified and to support multiple characters for column and pivot delimiters. When the Top Node Keyword parameter is configured in an extract, the specified value is output in the Parent column for rows in the extract file that include top node information. The Delimiter Characters extract and load parameter now enables multiple characters to be specified for delimiting columns of data in an extract or load process. The Pivot Delimiter extract parameter allows multiple characters to be used for pivoting a list of values as separate rows in the results of an extract.
Business Benefit: Custom top node identifiers and multiple delimiter characters can be used in an extract or load process for external applications that require it.
Key Resources
- Specifying Extract Options in Administering and Working with Enterprise Data Management
- Specifying Load Options in Administering and Working with Enterprise Data Management