All fields in DSPConstruct Source should be included in import to dsw Source Table

None of the zLegacy fields or zSource are included in the Assemble Package created in AutoGen to import the Constructed data from sdbDSPConstruct to the dswXXX Source Table.

We must modify the package each time AutoGen is used for a FullConstruct source. Since the goal of our project is to utilize Templates to migrate data, we have over 70 FullConstruct templates.

For a better understanding of DSP6.6 FullConstruct automation results, see the attached documentation of a sample FullConstruct Source Target.

  • Target Design
  • FullConstruct Table Design
  • FullConstruct Page Horizontal View
  • FullConstruct Page Column Configuration
  • Assemble Package for stTABLE Import
  • stTABLE Design

NOTE: None of the above elements are configured alike

Also see https://dsp.ideas.aha.io/ideas/MIGRATE-I-165 which addresses the need for zLegacy fields in the FullConstruct Horizontal/Vertical View

  • Tracey Karanovich
  • Oct 15 2017
  • Shipped
Advanced Data Migration (SST) / Autogen
  • Oct 18, 2017

    Admin response

    I agree that all fields in the DCS Table should be included in the Assemble package and imported into the Transform source table. 

  • Attach files
  • Tracey Karanovich commented
    19 Oct, 2017 05:18am

    Attaching Workbook with tab for each element generate for FullConstruct Source Target

    Issue2 FullCons...
    Attachments Open full size
  • John Grippa commented
    18 Oct, 2017 05:03pm

    Tracey,

    Please attach the documents you mention in the idea. 

    Attachments Open full size

Related ideas