I am attempting to create multiple nests in my json output within denodo.
I have the following vql statement in the derived view;
OR REPLACE VIEW dv_view2_name FOLDER = '/03 - business entities/project/03 - derived views' AS
Hi Denodo Team,
I have created a base view with 3 employee records for Dept_id= 'D100' as below. SELECT 'D100' AS dept_id , 'E1' AS empid FROM DUAL UNION SELECT 'D100' AS dept_id , 'E2' AS empid FROM DUAL UNION SELECT 'D100' AS dept_id , 'E3' AS empid...
I was wondering what would be the best way to create ARRAY inside an ARRAY, especially when you have huge data source(8M records)? I achived it using derived views but because of the data, when I create the 2nd ARRAY with ARRAY( from the derived v...