Usage Of Universe Stage
Posted: Mon Aug 27, 2007 6:11 am
Hi,
I have a Source Table in remote on which i fire a SQL and put all the result into a staging table residing locally
From the staging table i do the aggregation or some selection based on where clauses etc and put into next table.
Now i wanted to know instead of a staging table can i use a Universe table?
Considering performance and storage which is a better option to use.
Please let me if my question is not clear enough or you need more information.
Thanks & Regards,
Suresh N
I have a Source Table in remote on which i fire a SQL and put all the result into a staging table residing locally
From the staging table i do the aggregation or some selection based on where clauses etc and put into next table.
Now i wanted to know instead of a staging table can i use a Universe table?
Considering performance and storage which is a better option to use.
Please let me if my question is not clear enough or you need more information.
Thanks & Regards,
Suresh N