Reputation: 2455
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
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.
Upvotes: 1