Hi ,

To get data from 'n' number of tables you can use the JOIN predicate. But personally I feel joining more tables will always hinder the process and data fetching...

Hi ,

As I understand from your query , you want to create a SSAS cube from the excel data. If I am correct then the below link should help...

CDC in SQL Server 2008 would be a step to start for incremental load.

Good Question. Thought both would truncate to 'GIV' and 'GIV'. Should have been more thoughtful.:-)

Thanks for the info

By huge time I mean some queries take more time to execute on an average say 3 min and more.These are the queries which i need to update on...