Sample InfoSphere DataStage and InfoSphere QualityStage CSV output file data

The sample data illustrates the output format for the CSV files that IBM® InfoSphere® DataStage® and IBM InfoSphere QualityStage® must produce. In order for IBM Product Master to import the data, the output file must be in this format.

Table 1. Sample CSV output file data
JobID RecordID Name Value
13 123 Catalog Loader_Catalog
13 123 ActionMode Update
13 123 Loader_Primary_Spec/pk 10
13 123 Loader_Primary_Spec/diplay_name name
13 123 Loader_Primary_Spec/currency_attr 123
13 123 Loader_Primary_Spec/grouping/child1 child1value
13 123 Loader_Primary_Spec/grouping/child2 child2value
13 123 Loader_Primary_Spec/multioccur_attr#0 first occurrence
13 123 Loader_Primary_Spec/multioccur_attr#1 first occurrence
13 124 Catalog Loader_Catalog
13 124 ActionMode Update
13 124 Loader_Primary_Spec/pk 11
13 124 Loader_Primary_Spec/diplay_name 11name
13 124 Loader_Primary_Spec/relationship_attr Loader_Catalog|10;
13 125 Catalog Loader_Catalog
13 125 Category Loader_Hierarchy|cat1
13 125 ActionMode Update
13 125 Loader_Primary_Spec/pk 12
13 126 Catalog Loader_Catalog
13 126 ActionMode Update
13 126 Loader_Primary_Spec/pk 13
13 127 Catalog Loader_Catalog
13 127 Category Loader_Hierarchy|cat1
13 127 ActionMode Update
13 127 Loader_Primary_Spec/pk 14
13 128 Catalog Loader_Catalog
13 128 ActionMode Update
13 128 Loader_Primary_Spec/pk 15
13 129 Catalog Loader_Catalog
13 129 Category Loader_Hierarchy|cat1
13 129 ActionMode Update
13 129 Loader_Primary_Spec/pk 16
13 130 Catalog Loader_Catalog
13 130 ActionMode Update
13 130 Loader_Primary_Spec/pk 17
13 131 Catalog Loader_Catalog
13 131 ActionMode Update
13 131 Loader_Primary_Spec/pk 18
13 132 Catalog Loader_Catalog
13 132 ActionMode Update
13 132 Loader_Primary_Spec/pk 19