etl related issues & queries in DbaXchanger

How to Represent a VARCHAR Column with XML Data in a Fact Table?

database-design data-warehouse etl dimensional-modeling
Updated February 11, 2019 20:06 PM

SQL Kimball Data Warehouse ETL Create Pipeline

sql-server database-design data-warehouse etl star-schema
Updated February 07, 2019 05:06 AM

DB2 Database Conversion Workbench Issue

sql-server db2 etl
Updated February 05, 2019 19:06 PM

When to Disable and Recreate Indexes in Data Warehouse ETL?

sql-server performance-tuning data-warehouse sql-server-2017 etl
Updated February 02, 2019 16:06 PM

Datawarehouse Staging Tables: Null or Not Null

sql-server data-warehouse sql-server-2017 etl
Updated January 09, 2019 19:06 PM

Data Warehouse Instrumentation and Metadata - Recording Business Logic Decisions

data-warehouse etl metadata architecture business-intelligence
Updated December 18, 2018 21:06 PM

Tool for ETL in oracle 11g

oracle-11g data-warehouse etl
Updated December 10, 2018 20:06 PM

How to compare data between staging and operational tables?

sql-server etl except
Updated December 04, 2018 20:06 PM

Quick way to validate two tables against each other

sql-server sql-server-2008-r2 etl except
Updated November 30, 2018 20:06 PM

QUERY or ETL PROCESS TO INSERT DATA INTO FACT TABLES in SSMS

sql-server ssis ssms etl
Updated November 27, 2018 23:06 PM

How can I load csv data into mongodb and choose the types I'd like to have created for each column?

mongodb import etl load
Updated November 27, 2018 21:06 PM

AI-proof SQL jobs

sql-server query data-warehouse etl cloud
Updated November 27, 2018 11:06 AM

Increase frequency of updates (ETL process) to Data Warehouse

sql-server data-warehouse etl
Updated November 21, 2018 03:06 AM

SQL Staging Tables: Primary Key Clustered or Heap

sql-server database-design sql-server-2016 performance-tuning etl
Updated November 10, 2018 10:06 AM

SSIS Installation on Dedicated Server

ssis installation etl ssis-2016
Updated November 09, 2018 13:06 PM

DATA ETL methodology

mysql database-design etl
Updated November 07, 2018 00:06 AM

Efficiently bulk upsert unrelated rows

sql-server transactional-replication etl upsert table-valued-parameters
Updated November 01, 2018 20:06 PM

Export to EXCEL multiple excel files from multiple grids

sql-server t-sql ssis etl
Updated November 01, 2018 18:06 PM

Database administration in "start-up" companies

sql-server sql etl business-intelligence
Updated October 21, 2018 16:06 PM

How to copy selected table data from sql server to mysql on a daily basis?

sql-server mysql migration etl copy
Updated October 19, 2018 13:06 PM

SSIS ETL or CDC - real time DWH reporting

sql-server sql-server-2012 data-warehouse etl
Updated October 17, 2018 21:06 PM

Fastest Way to find data difference between two tables

sql-server sql-server-2016 etl change-data-capture incremental-load
Updated October 15, 2018 19:06 PM

Are there good ETL tools to work with Restful APIs and PostgreSQL databases in a flexible way?

postgresql etl
Updated October 08, 2018 15:06 PM

Daily data import from private cloud database

ssis import etl
Updated October 05, 2018 14:06 PM

reseed auto_increment to specific number?

sql-server mysql etl auto-increment
Updated October 02, 2018 10:06 AM

Can ETL access Data while Rebuild Index Operation is running

sql-server index sql-server-2014 etl
Updated September 23, 2018 18:06 PM

SSIS Package Execution Completes But Does Nothing

sql-server sql-server-2012 ssis etl
Updated September 20, 2018 15:06 PM

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

Showing Page 1 of 0