ETL
ETL , Esper or Drools?
The question environment relates to JavaEE, Spring I am developing a system which can start and stop arbitrary TCP (or other)开发者_StackOverflow社区 listeners for incoming messages. There could be a[详细]
2022-12-30 04:35 分类：问答Import data from an SSRS report via SSIS package
First, I ask that you not ask \'why.\'In the famous words of Tennyson \"Ours is not to reason why. Ours is but to do and die.\" It\'s one of those, \"This is what you have, deal with it.\" situations.[详细]
2022-12-29 22:53 分类：问答Can you safely rely upon Yahoo Pipes to offload ETL for your application?
Yahoo Pipes are a very intriguing choice for sort of a poor-man\'s server-free ETL solution, but would it be a good idea to build an application around one or many Pipes?I\'ve really only used them fo[详细]
2022-12-29 19:27 分类：问答What is the best FREE solution to implement one ETL project in MySql [closed]
Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.[详细]
2022-12-28 19:56 分类：问答Handling primary key duplicates in a data warehouse load
I\'m currently building an ETL system to load a data warehouse from a transactional system. The grain of my fact table is the transaction level. In order to ensure I don\'t load duplicate rows I\'ve p[详细]
2022-12-28 14:02 分类：问答Transforming large XML for SQL Server insertion
Our state government has opened its transport timetable data. The data is in xml based TransXchange standard format.[详细]
2022-12-28 02:10 分类：问答SSIS - How to access a RecordSet variable inside a Script Task
How do you access a Rec开发者_如何转开发ordSet variable inside a Script Task?Listed below is the code I used to load a datatable in a C# script task from a recordset or resultset variable. \"User::tra[详细]
2022-12-26 16:04 分类：问答ETL mechanisms for MySQL to SQL Server over WAN
I’m looking for some feedback on mechanisms to batch data from MySQL Community Server 5.1.32 with an external host down to an internal SQL Server 05 Enterprise machine over VPN. The external box accu[详细]
2022-12-25 12:02 分类：问答Python - CSV: Large file with rows of different lengths
In short, I have a 20,000,000 line csv file that has different row lengths. This is due to archaic data loggers and proprietary formats. We get the end result as a csv file in the following format. MY[详细]
2022-12-25 00:10 分类：问答PostgreSQL to Data-Warehouse: Best approach for near-real-time ETL / extraction of data
Background: I have a PostgreSQL (v8.3) database that is heavily optimized for OLTP. I need to extract data from it on a semi real-time basis (some-one is bound to ask what semi real-time means and[详细]
2022-12-24 12:41 分类：问答
加载中,请稍侯......