DependOn

table category: table-control no `||` resultSize: 1

Declares that the current CDM table must not be transformed before another named table is loaded.

Use DependOn to express a load-order requirement that the engine cannot infer from the Rabbit-in-a-Hat model. The most common case is a foreign-key relationship in the destination database: the engine does not see those constraints, so a DependOn rule on the dependent table is what guarantees the parent table is fully loaded first.

Beware that DependOn can introduce cycles between CDM tables. The engine does not break cycles automatically; if a cycle exists, neither table is loaded.

Parameters

1 — table Mandatory — accepts: table reference (@-notation)

The CDM table that the current table depends on.

Requires

• The referenced CDM table must exist.

Examples

DependOn(@location)

See also

Join, LeftJoin