Top "Etl" questions

ETL is an acronym for Extract, Transform, and Load.

Informatica writes rejected rows into a bad file, how to avoid that?

I have developed an Informatica PowerDesigner 9.1 ETL Job which uses lookup and an update transform to detect if the target …

data-warehouse etl informatica informatica-powercenter
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 …

postgresql data-warehouse etl near-real-time data-extraction
Is there any way to trigger a AWS Lambda function at the end of an AWS Glue job?

Currently I'm using an AWS Glue job to load data into RedShift, but after that load I need to run …

aws-lambda etl aws-glue
How do I unit test and integration test my SSIS packages?

This question mentions two libraries, both of which aren't maintained and one has broken links to the source and documentation. …

sql-server unit-testing ssis integration-testing etl
Pentaho Kettle conversion from String to Integer/Number error

I am new to Pentaho Kettle and I am trying to build a simple data transformation (filter, data conversion, etc). …

csv pentaho etl kettle data-integration
SSIS:File System Task 'Could not find file'

I am working on a SSIS project that download a file via web and upload the data in sql server …

sql-server ssis etl sql-server-data-tools ssis-2012
SSIS - fill unmapped columns in table in OLE DB Destination

As you can see in the image below, I have a table in SQL Server that I am filling via …

sql sql-server ssis etl dataflow
Strategy to load a set of files in Talend

I want to know which is best strategy to aboard the following problem in Talend: I need to load data …

etl talend
Batch convert visual foxpro dbf tables to csv

I have a huge collection of visual foxpro dbf files that I would like to convert to csv. (If you …

csv etl foxpro dbf visual-foxpro
Best Practise to populate Fact and Dimension Tables from Transactional Flat DB

I want to populate a star schema / cube in SSIS / SSAS. I prepared all my dimension tables and my fact …

database ssis ssas etl business-intelligence