etl related queries in DbaXchanger | QueryXchanger

Is it possible to use ETL from my normalized database/tables to put data into a denormalized database/tables for data warehousing?

database-design normalization etl database-denormalization azure-sql-data-warehouse
Updated September 01, 2018 11:06 AM

Handling variable fields in a CSV file with JSON?

postgresql import json etl csv
Updated August 16, 2018 19:06 PM

Index Maintenance for DW- DB ( ETL process )

sql-server index-tuning data-warehouse etl index-maintenance
Updated July 30, 2018 17:06 PM

Is it bad practice to use a data-warehouse for providing reorganized non-BI data?

data-warehouse etl
Updated July 12, 2018 08:06 AM

SQL Bulk import vs SSIS in Simplicity

sql-server sql-server-2012 ssis etl bulk-insert
Updated July 11, 2018 06:06 AM

SSIS - dynamically merging a group of files

sql-server ssis etl ssis-2016
Updated May 21, 2018 14:06 PM

Multiple Agent Jobs Running same SSIS Package

sql-server ssis sql-server-agent etl
Updated May 17, 2018 20:06 PM

Partial Database Migration: Dealing with CRUD Queries

ssis migration etl
Updated April 25, 2018 15:06 PM

SSISDB too large

ssis etl
Updated April 13, 2018 19:06 PM

Data warehousing (ETL): Scheduled data migration from MySQL to PostgreSQL

mysql postgresql etl automation
Updated April 10, 2018 08:06 AM

Looking to clean up this ETL code - PasteThePlan included + Bonus Architecture question

sql execution-plan etl architecture
Updated April 05, 2018 18:06 PM

Load New Foreign Key in Facts Table, When Update Dimension with SCD Type 2

sql-server ssis etl business-intelligence
Updated April 03, 2018 19:06 PM

Confusion in Informix when selecting dates with JOIN

sql etl informix ibm-data-studio
Updated March 31, 2018 20:06 PM

Single User Mode and Replication

sql-server-2014 transactional-replication etl
Updated March 28, 2018 15:06 PM

Copying large amounts of data to another target tables

sql-server migration performance-tuning etl
Updated March 06, 2018 18:06 PM

Databases Integration

database-design etl dblink integration
Updated February 01, 2018 00:06 AM

SQL Server Shared Memory Provider Timeout

sql-server ssis etl
Updated January 22, 2018 15:06 PM

Data Warehouse: Staging Area, DWH databases and ETL tool on one server?

data-warehouse etl architecture
Updated January 07, 2018 17:06 PM

Approaches for handling nvarchar sources to data warehouse

sql-server data-warehouse etl
Updated December 16, 2017 01:06 AM

I need to generate a GUID,help

sql ssis etl uuid
Updated November 30, 2017 22:06 PM

Restoring MSSQL back-ups to Oracle 12c

sql-server-2008 backup oracle-12c etl
Updated November 28, 2017 23:06 PM

How can I SELECT an 'instance' in PostgreSQL?

postgresql stored-procedures trigger etl change-data-capture
Updated November 22, 2017 18:06 PM

UPSERT or INCREMENTAL update of table but with DELETE

postgresql etl upsert
Updated November 15, 2017 11:06 AM

Data transformation

sql-server migration data-warehouse etl
Updated November 15, 2017 11:06 AM

SQL SSIS Closing Files already in use

sql-server ssis etl hardware
Updated October 21, 2017 18:06 PM

ETL SSIS Internal Company

sql-server ssis etl hardware
Updated October 21, 2017 07:06 AM

Existing data to new table, how to set up the PK & Identity

sql-server primary-key etl identity
Updated October 13, 2017 18:06 PM

Does ELT data end up in an RDBMS?

etl
Updated October 12, 2017 17:06 PM

Is ELT appropriate for life critcal applications such as Medical Systems when converting to a new application?

etl business-intelligence
Updated October 12, 2017 16:06 PM

Handling delayed key info in real time data warehouse

data-warehouse etl
Updated October 02, 2017 18:06 PM

How Does SSIS Manage Connection Traffic?

sql-server ssis data-warehouse etl
Updated September 27, 2017 00:06 AM

How to extract and store errors from Pentaho PDI

etl pentaho
Updated September 20, 2017 21:06 PM

How to setup a new Data warehouse, MS SQL or Sybase?

sql etl sybase
Updated September 19, 2017 03:06 AM

We are in the early stages of building a data warehouse - looking for a good mapping tool?

data-warehouse etl tools
Updated September 13, 2017 18:06 PM

SSIS - Iterative Data Flow Task with Schema Differences

sql ssis schema etl
Updated September 06, 2017 19:06 PM

Import data into Apache Spark

etl hadoop
Updated September 05, 2017 02:06 AM

SSIS multiple parallel ETL: Task Scheduler or Service Broker

sql-server ssis etl service-broker
Updated August 14, 2017 07:06 AM

SSIS ETL benefits, when to use and not use

sql-server ssis etl
Updated August 13, 2017 18:06 PM

SSDT no avaible input column error

etl data-quality-services
Updated August 03, 2017 09:06 AM

Huge Size (still) with Differential Backup

sql-server index backup data-warehouse etl
Updated July 30, 2017 13:06 PM

ETL Job Issue - Works for One Server and Not for other

t-sql sql-server-2014 etl
Updated July 01, 2017 15:06 PM

SQL Server : ETL Stage Index

sql-server index ssis data-warehouse etl
Updated June 28, 2017 10:06 AM

Optimize SSIS package for fewer queries

ssis etl ssis-2012 dts
Updated June 21, 2017 14:06 PM

SSISDB Transaction Log Backup

sql-server ssis sql-server-agent etl
Updated June 19, 2017 11:06 AM

Parallel lookup in tMap

etl
Updated June 16, 2017 12:06 PM

MS SQL servers in different countries linked for ETL via SP

stored-procedures linked-server etl
Updated June 15, 2017 10:06 AM

Update a field value if the column 1 and column 2 of a SQL table matches with column 1 and column 2 in an Excel spreadsheet

sql-server etl excel
Updated May 31, 2017 20:06 PM

ssis ado.net destination has failed to acquire the connection

sql-server sql-server-2008-r2 ssis etl ssis-2012
Updated May 30, 2017 12:06 PM

Replicating data to a head office with limitations

sql-server database-design replication data-warehouse etl
Updated May 19, 2017 20:06 PM

ssis surrogate key in parent child tables

ssis data-warehouse etl
Updated May 10, 2017 03:06 AM

etl related issues & queries in DbaXchanger