Exporting Records with Category Specific Attributes

When exporting records, you can export category specific attributes and also the associated classification codes.

Procedure

  1. Create an output map in MDM Studio by selecting appropriate classification schemes. For more information on creating output maps in MDM Studio, refer to the TIBCO MDM Studio User’s Guide.
  2. Map the classification scheme logical levels with the Sync Format columns in MDM Studio. For more information on how to do this mapping in MDM Studio, refer to the TIBCO MDM Studio User’s Guide.
    • The mapping of Category Specific Attributes with Sync Format columns is similar to the normal attributes mapping and only the explicitly mapped attributes are output.
    • If one or more Logical Levels of any Classification Scheme associated with an Output Map are mapped with the columns in Synchronization Format, then the codes corresponding to those levels are populated in appropriate columns in OUTPUT_*.txt file. This mapping is represented by Source Expression "@classificationSchemeName.logicalLevelName".
    • If there are no mappings for Logical Levels of Classification Scheme associated with Output Map, then separate output file for each such Classification Scheme is created with the following file name format:
      <catalogName>_<schemeName>_timestamp.txt

      Header for these files:

      CATALOGID,PRODUCTID,PRODUCTIDEXT,LEVEL1,LEVEL2,...,Level_N
      Note: LEVEL1, LEVEL2, and so on are the actual logical level names in the respective classification schemes.
    • If records in a Repository are classified in a scheme which is NOT associated with Output Map, records classification data for that scheme is not present in the Synchronization output.
  3. Create a synchronization profile.
  4. Create a subset for the set of data that needs to be exported. Select records based on the classification codes. The "or" operation or "in" operation is supported; this allows you to select records which fall into multiple categories. For more information, refer to the TIBCO MDM Studio User’s Guide.