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
I\'m trying to work with a 2.5Gb text file, which comprises 293 fields in a tab-开发者_如何学JAVAdelimited extract.
I\'m using MySQLdb and Python.I have some basic queries such as this: c=db.cursor() c.execute(\"SELECT id, rating from video\")
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.
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.
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
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
What is the best end-user language开发者_如何学运维 for data transformation (ETL), ideally something that can run in a JVM (with a LGPL like license).
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
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
加载中,请稍侯......