TDM Subset: Joining tables that are part of complex UNIONS and Selects

Document ID : KB000107902
Last Modified Date : 26/07/2018
Show Technical Document Details
Issue:
We have a complex query with Select with in a Select and has UNION in the query. While building a subset for this, we are seeing some limitations to add a AND clause. During a Webex with Engineering, we found that Data Maker processing is not honoring the excluded tags for the tables which are not needed.
Environment:
TDM 4.5
Subset
Resolution:
This issue has been addressed in the following patches:SubSet-4.5.500.12.zip and GTDataMakerPB-4.5.1.49.zip. This fix will use a new entry in the file extract called InSelect. This new entry will be picked up by datamaker through the transformation map when saving a map and linking it to a GT subset. A new option can be seen called 'SQL Join Ex' which will use the InSelect entry.

Please contact CA Support for these versions or if you are installing a GA Version after 25July2018, please contact CA Support to verify that these fixes are in the GA version you are installing.
Additional Information:

Video URL on how to open a Support Case - https://communities.ca.com/videos/5898-demo-how-to-open-a-support-case

You can download the latest version of TDM by following the directions in this document: https://support.ca.com/us/knowledge-base-articles.TEC1903942.html.   

To contact support, go to https://www.ca.com/us/services-support/ca-support/contact-support.html