Question : Question: I have a script with around 45 thousand insert from select statements. When I try and run […]
Tag: etl
How to copy selected table data from sql server to mysql on a daily basis? [closed]
Question : Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this […]
Dodgy causes of ORA-12549?
Question : I am dealing with a rather massive ETL processing which keeps throwing me the ORA-12549 error. Have been […]
Tablespace on ephemeral storage
Question : For performance reasons in some scenarios, e.g. Amazon EC2, you have access to a faster and cheaper storage […]
SQL Server: Database integration and synchronization
Question : I have n SQL Server databases with the same data schema. On the other hand i have a […]
SQL SSIS Closing Files already in use
Question : Sometimes when running SSIS packages on flat files, I receive error: “The process cannot access the file because […]
150 External flat files used to create internal DB
Question : I have a situation in which I must create an entire DB off of ~150 external txt files […]
PostgreSQL importing thousands of columns as an array
Question : PROBLEM: I have a CSV file with 16,382 columns with data that looks like this: +————-+———–+——+——-+——+——+——+—–+——-+—–+ | PATIENT_ID […]
How do you extract discount data from SAP?
Question : I’m not a SAP developer. We already have a big SSIS package that pulls data from the SQL […]
how to insert multiple columns(around 40) into my sql database using java
Question : i have a program to read the content of an excel file to my-sql db. i have 40 […]