Optimized Bulk Loading of Data into Oracle

21/06/2013

SQL Server 2008 and SQL Server 2008 R2 (Enterprise and Developer editions) support bulk loading Oracle data using Integration Services packages with the Microsoft Connector for Oracle by Attunity. For SQL Server 2005 and the non-Enterprise and non-Developer editions of SQL Server 2008 and 2008 R2, there are alternatives for achieving optimal performance when loading Oracle data. This paper discusses these alternatives.The Enterprise and Developer editions of SQL Server 2012 also support bulk loading Oracle data using Integration Services packages with the Microsoft Connector for Oracle by Attunity. To review the document, please download the Optimized Bulk Loading of Data into...
תגיות: , , , ,
אין תגובות

CDC for Oracle in SQL Server 2012

One of the new features introduced in SQL Server 2012 is the ability to use SQL Server CDC for tracking changes on an Oracle table. In the following post you will understand how to setup such a service for tracking changes on your Oracle tables.Configuring your Oracle serverBefore creating the service, you must ensure that the following configuration steps have been performed on your source Oracle database:1. The database is set to ARCHIVELOG and is OPEN2. The user that is going to connect to the Oracle database has DBA privileges on the database (since you will look up the...
תגיות: , , ,
אין תגובות

SSAS distinct count wrong results

14/06/2013

I have added a connect item today.please vote for it: https://connect.microsoft.com/SQLServer/feedback/details/790216/ssas-distinct-count-wrong-results Issue:ssas distinct count results wrong number.While querying the table as follow: SELECT count (distinct USER_ID ) FROM Table I get this results -- 1033612while querying SSAS I get 257.sample data for USER_ID:42348-3648-1368306010878-D41D8CD98F00B204E9800998ECF8427E42348-3648-1368074987484-B26463A0EE1A5F27718A14533D020E6042348-3648-1368011144064-65DD703A82FFA13A98305295317C86AD42348-3648-1368049679418-D41D8CD98F00B204E9800998ECF8427EI have also tried to convert this Varchar(100) into checksum()sample data -235875173535581043287814888-1894147417still getting same results.the measure is located in stand alone measure group. and configured with default settings.Solution: No Solution so far.
אין תגובות

"GeoFlow" for Excel 2013

07/06/2013

 Project codename “GeoFlow” Preview for Excel 2013 allows you to plot geographic and temporal data visually, analyze that data in 3D, and create interactive tours to share with others. This preview gives you an early look into the new features that provide 3D data visualization for Excel and a powerful method for people to look at information in new ways, enabling discoveries in data that might never be seen in traditional 2D tables and charts.download it from here->
תגיות: , ,
תגובה אחת