Can anyone please explain me,
1. why do we remove 'red relationships' in subset tool when building an extract.
2 How does the subset tool knows the table relationships? where/how these things are fed into tool?
1. Relationships that go from a child table back up to a parent table are displayed in red. These relationships indicate you are moving up to a parent and potentially moving back down to children. This may be correct for your particular extract, however, generally parent or reference tables are usually moved separately from transactional data.
2. GTSubset knows the relationships by querying the database to retrieve the DDL of the database.
2. When we select any table, how does it fetch all its children tables. Its before even writing up the query.
Each time you select a table to be used as the driven table in the subset, the tool queries the database to retrieve the DDL for that table. The DDL does include the constraints which are used to build the relationships in the tool.
When you say "to build the relationships in the tool", is it Subset tool? If yes, how to build?
Correct it is the subset tool how builds the relationships, and those are build by querying the constraints of the table.
Thank you so much Peter.
If you find some time, please have a look at https://communities.ca.com/message/242037024-adding-extra-flag-columns-in-insert-statement as well.
Retrieving data ...