ETL
How to achieve similar datatype
Goal: Combine two column named first and lastname, from the same table A and then transfer it to column fullname in ta开发者_开发技巧ble B from a another[详细]
2023-03-31 03:00 分类：问答Can SQLite import only specified fields from a large textfile?
I\'m trying to work with a 2.5Gb text file, which comprises 293 fields in a tab-开发者_如何学JAVAdelimited extract.[详细]
2023-03-30 13:58 分类：问答What's the most efficient way to convert a MySQL result set to a NumPy array?
I\'m using MySQLdb and Python.I have some basic queries such as this: c=db.cursor() c.execute(\"SELECT id, rating from video\")[详细]
2023-03-28 16:02 分类：问答Data cleansing : user entered database data tools
We got a database with some redundant, bad data. As example some names of articles have an uppercase开发者_如何学C lower-case difference, other a problem of accent, others a missing letter and so on.[详细]
2023-03-28 07:39 分类：问答Bulk importing text files / VB2005 / SQL Server 2005
I\'ve inherited a .NET app to support / enhance which reads in a couple of files of high hundreds of thousands of rows, and one of millions of row.[详细]
2023-03-27 11:29 分类：问答ETL into operational oracle database - used by jsp/spring/hibernate app
I am needing to have some legacy data loaded into an operational oracle (11gR2) database. The database is being used by a jsp/spring/hibernate (3.2.5.ga) applicat开发者_开发问答ion. A sequence is used[详细]
2023-03-26 21:50 分类：问答How to set length for a numeric column and datetime in SSIS?
I do have a flat file (csv file) which is extracted and loaded to another flat file by its position. For example I do have 3 columns like Record type, Emp number and dat开发者_运维知识库e with a posit[详细]
2023-03-26 02:42 分类：问答Best language for data transformation (ETL)
What is the best end-user language开发者_如何学运维 for data transformation (ETL), ideally something that can run in a JVM (with a LGPL like license).[详细]
2023-03-25 14:10 分类：问答SSIS 2008 using the same variable for a row count and a script component
I have a row count component that uses a global variable X to store the number; up to this point it rules but then if I add a script component that has X 开发者_JAVA百科among its ReadOnly variables an[详细]
2023-03-25 08:34 分类：问答How to populate star schema database with data from CSV file using jasperETL?
I\'m new to jasperETL and i have to populate star schema database with data from CSV file. Does anyone know how to perform this task? Maybe there is some tutorial or book, where i can find this inform[详细]
2023-03-22 14:29 分类：问答
加载中,请稍侯......