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

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

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.