Hi,
We have two queries loading Data into one of the Marts.
Basically we are using two SQLs which fetch the data there is a UNION between the two queries.
We are thinking of using a temp table approach wherein the two SQLS will load the data to the temp tables and then will use UNION for results.
From your experience please suggest which is a better approach.
Regards,
Narayan