我与仓储进程混为一谈。 正在开发数据过程中的Im,但我不真正理解的那部分与ube有关。 我先读过一些关于SSAS的论文,但我看不出我如何在其他应用中使用这一数据。 我需要的是:
部分我不理解是ube。 我看到,许多人利用SSAS建造ube。 SSAS中这些多瑙河? 他们是否反对? 它们是否对数据储存进行表态? 我的网络服务如何从圆顶上获取数据?
是否有任何替代标准? 仅仅在一种数据中 build立并装在电子设备处理过程中的ube子,是否可行?
多瑙河是按格式分类的数据储存库,使报告效率大大高于在相关数据库储存中可能做到的。 在SSAS中,你有几种选择,选择如何最终储存你的数据,但一般都储存在OS档案系统中。 也可以按照您的版本水平,通过其他几种方法(使用称为MDX的专用查询语言)查询。 你可以利用微软公司的适当司机,为你的网络服务建立链接。 我对数据的含义不知。 您是否以粗chem的形式提到关系表? 如果是的话,这些通常是实际河流的前体。 从报告观点来看,你不会像你那样利用这些连接来源(因为一个多瑙河在你星形表界定的中间空间中储存每个噪音(或图)的合计数)来获得同样的好处。 为了解释这一点,如果我有一份关系仓库(即使是以星体形式出售),而且我想为某个地点获得一个特定日期的销售美元,我不得不对一个非常庞大的销售情况表提出质询,并加入地点和日期的分位表(可能也非常大)。 如果我想要一英河提供同样的数据,我就界定了我的多瑙河过滤器和数据集查询,即单线从数据中提取数据,并更快地予以回报。
采用SSAS有许多替代办法,但如果你使用一个数据库,则每种办法都将是一种ube。 如果你拥有大量数据集,则设计得当的立方位将进行多面查询的链接数据。
If I can do the required ETL requirements using stored procedures, any advantages of using SSIS packages instead? My ETL stuff is nothing major. I feel like using an old technology. I like SQL. Old ...
I am using SSIS and I need to transform a date. How can I transform a date in String format (e.g. 14/09/1980) to the same but in date format in VB.NET? I would like the datetime format to insert it ...
I have written a SSIS 2005 script task that connects to Active Directory and reads user accountnames to store in database. I was able to successfully test this on my local system by executing dtexec....
I want to know how to import .mdb (MS Office 07) file into Sql server 2008 by SSIS. I need to run this ETL packet in such a way that it checks for duplicates, and if any doesnt re-insert them, but ...
I need to execute 29 ssis packages. So planning to create one master package which will execute all these packages. I don t know how to implement this. Can you please explain in brief. Thanks in ...
I have a server that has a SQL Agent job setup to run a two part datawarehouse build and Analysis Services cube build. The job ran successfully until there was a problem with Management Studio and ....
In SSIS 2008, the ability to reference other class libraries has been added. Is there anyway to resolve the references to a non-GAC location when deployed to a non-developer environment? For instance, ...
I am looking for any tips or resources on importing from excel into a SQL database, but specifically when the information is NOT in column and row format. I am currently doing some pre-development ...
