hi teradata experts,
In my Project,(in most of the teradata queries ) i am using one Derived table (using With clause)
which is attached to Main query, which is very good in terms of performance and implementation
as it takes spool space only one time however it can be used any number of times in the main
but the issue is that there is a limitation of using only one derived table using WIth clause.
Is there any way out that we can use more than one derived tables?
I got my answer... Good news is that teradata 14 is providing the flexibility of using the 2 WITH clauses in SQL.