DMW Copy Transformation Issue With Table Alias (Doc ID 2812070.1)

Last updated on JULY 13, 2023

Applies to:

Symptoms

On Oracle Life Sciences Data Management Workbench (DMW) 3.0.0 version,

ACTUAL BEHAVIOR
---------------
When trying to copy transformation with source transformation having Join between a table and more than 1 filter table using alias, only one of the filter table mapping is copied and the join is missing.

EXPECTED BEHAVIOR
-----------------------
Expected to see all selected table mapping to be copied together with the Join.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  1)  Create a Source DM
  2)  Create a Target DM's  example: TST1 and TST2  
  3)  Map Conmeds table with Demo and Conmeds (C1, C2 using Alias)
  4)  Give the join condition as Study ID = Study ID on Conmeds(C1) and Demo
  5)  Map few columns with C1.CONMEDS
  6)  Map few columns with C2.CONMEDS
  7)  Map few columns with DEMO
  8)  Mark other columns as not used
  9)  Install the XFM map "TST1"
10) Now select "TST2", add source and copy the XFM for CONMEDS table using Copy from another XFM

11) Mapping's done using CONMEDS(both C1 and C2) are not visible in the mapping screen
      Click on Accept selected Mappings

Expected Result:
     All mappings should get copied and also Join condition should be there
Actual Result:     

     Mappings done using C1 and C2 are missing and also Join condition is not copied

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.