ETL
Build flat table from CSV files
I have 500 CSV files in this format: IndicatorA_Name.csv 190019011902 ... Norway32 Sweden133 Denmark 523 ...[详细]
2023-02-13 09:59 分类：问答How to reducing impact on OLTP when performing ETL Process
I am new in designing a ETL process. Currently I have two database, one is the live database where the application use it for every day transaction. The other one is the data warehouse.[详细]
2023-02-12 19:49 分类：问答Transfer large amount of data from DB2 to Oracle?
I need ever开发者_如何转开发y day to transfer large amounts of data (about several millions records) from db2 to oracle database. Could u suggest the best perfoming method to do that?DB2 will allow yo[详细]
2023-02-06 12:25 分类：问答ALTER TABLE NOCHECK CONSTRAINT timeout randomly
I have an C# application that performance ETL process. For self referencing table, the application will run \"ALTER TABLE [tableName] NOCHECK CONSTRAINT [constraintName]\" which turns off any FK const[详细]
2023-02-05 05:15 分类：问答Postgresql: COPY FROM csv file with occational missing columns
I have several billion rows of data in CSV files. Each row can have anything from 10 to 20 columns. I want to use COPY FROM to load the data into a table containing 20 columns. If a specific CSV row o[详细]
2023-02-02 02:29 分类：问答GeoKettle Pan/ Kitchen Hangs at New Database Defined
Pan/ Kitchen of Spatially enabled version of Pentaho Data Integration (Kettle) version 3.2 hangs at \'New Database Defined\'. I am trying to extract some data from a MS Sql Server 2005 table through[详细]
2023-02-01 08:28 分类：问答whats the best way to load a large amount of SQL data in .net and generate a CSV file?
i have a sql proc that returns 20,000 + records and want to get this data into a CSV for a SQL2005 bulk load operation.[详细]
2023-01-30 23:48 分类：问答Merging a stream with table input records NOT in the stream
I am trying to pull together a complex Kettle transformation on a set of patient data.I have several table input steps that query a MySQL table that assembles patient rows into a stream.Each table inp[详细]
2023-01-29 15:19 分类：问答Can I incorporate SSIS into my cloud application?
First the generalized problem: I need to make an ETL solution that users will be able to launch from a cloud application. I would like to make a solution where they do some simple mapping and my progr[详细]
2023-01-29 15:18 分类：问答Loading many flatfiles into SQL Server 2005
I have a very annoying task. I have to load >100 CSV-files from a folder to SQL Server database. The files have column names in first row. Data type can be varchar for all columns. The table names in[详细]
2023-01-29 00:07 分类：问答
加载中,请稍侯......