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.
This issue has been addressed in the following patches:SubSet-4.5.500.12.zip and GTDataMakerPB-220.127.116.11.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.
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.