Article - CS193194

Which staging table must be used when the staging database includes several tables with similar names (such as PartUsesOcr_xxxx) in Windchill Bulk Migrator

Modified: 09-Aug-2024   


Applies To

  • Windchill Bulk Migrator 4.0 M020 to 12.1

Description

  • Which staging table to load data to, when multiple tables with id exist in staging (such as PartUsesOcr_xxxx) ?
  • Which staging table to load data to, when multiple tables with id exist in staging (such as AFTDACTDATA_xxxx) ?
  • Which staging table must be used ? The staging DB includes several tables with similar names such as PARTUSESOCR__2116384130, PARTUSESOCR__2146687792 ... or WTPARTUSAGELINK__266822469, WTPARTUSAGELINK_1234180995 ...
  • It is not clear about columns meanings of table WTPARTUSAGELINK_1612602514 (IBAHLDROBJECTNUMBER, ...) and PARTUSESOCR__183353141 (LINKCNT, USEDBYMEMBERLINKOBJECTNUMBER, USEDBYMEMBERLNKOBJECTNUMBER, ...) in WBM Staging database.
This is a printer-friendly version of Article 193194 and may be out of date. For the latest version click CS193194