getInvolvedTables

API

public HashSet<String> getInvolvedTables(String definitionId)

Description

Return a Set of tables identifiers involved in a schema.

A schema can use a table in the following places:

• schema selection
• input validation
• an an inclusion/exclusion for a mapping
• the table path of a mapping

Examples

TNMStagingCSharp.Src.Staging.Staging staging = TNMStagingCSharp.Src.Staging.Staging.getInstance(CsDataProvider.getInstance(CsVersion.v020550));

// get all tables used in the "brain" schema"
HashSet<String> tables = staging.getInvolvedTables("brain");

Assert.AreEqual(61, tables.Count);
Assert.IsTrue(tables.Contains("schema_selection_brain"));
Assert.IsTrue(tables.Contains("ssf7_sqk"));
Assert.IsTrue(tables.Contains("ajcc6_n_codes"));
Assert.IsTrue(tables.Contains("ssf18_snm"));
Assert.IsTrue(tables.Contains("ajcc7_stage_una"));