Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
Concatenate Ordered Products, Returned Products, Replaced Products to One table and add a new field table_flag. Table Falag would be 1,2,3 for Ordered Products, Returned Products, Replaced Products table.
Use table_flag in Set analysis
load *, 1 as table_flag from Ordered Products;
concatenate
load *, 2 as table_flag from Returned Products;
concatenate
load *, 3 as table_flag from Replaced Products
Hi,
I had thought of one solution : joining Orders with Ordered Products and Returns with Returned/Replaced Products. Then using a link table linking Orders, Returns and Products. But I am worried about the performance overhead that might result because of the join.
Thanks and Regards,
Madhuparna Dhar