Adam
Adam

Reputation: 2455

Replacing Derived Table With Newly Created Table From Database in BO

I have created a derived table in data foundation layer (a table defined with sql statement). Now, I have decided that it would be a good idea to materialize that derived table, and I would like to create one in the database. The question is - is it possible to replace derived table with the newly created table from database WITHOUT having to define all connections to other tables again?

If yes, please explan how.

Thx! A.

(I am unsing IDT 4.1)

Upvotes: 0

Views: 1586

Answers (1)

DocZerø
DocZerø

Reputation: 8567

Yes, you can, and it's quite simple too. Just right-click the derived table that you created and select Replace By > Database Table from the context menu.

enter image description here

Upvotes: 1

Related Questions