@DerivedTable Function in IDT

@DerivedTable is a new function in IDT and its used within the derived Table and also called as “’derived table on a derived table”. @DerivedTable function in the definition of nested derived tables and is a table that is derived from at least one existing derived table.

The syntax of the @DerivedTable function is:

@DerivedTable(<Derived table name>)

<Derived table name> is the name of the derived table you want to reference and it should be defined within double quotes. The @DerivedTable function is only used in the definition of derived tables in the data foundation.

Insert Derived table in Data foundation:

Derived Table “Region_Sales_derived” created.

This “Region_Sales_Derived” derived table will be used in another derived table using @DerivedTable function.

Note: In database-specific SQL (multisource-enabled data foundations), all tables referenced must be from the same connection.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.