Toggle navigation
Categories
ServerfaultXchanger
SuperuserXchanger
UbuntuXchanger
WebappsXchanger
WebmastersXchanger
ProgrammersXchanger
DbaXchanger
DrupalXchanger
WordpressXchanger
MagentoXchanger
JoomlaXchanger
AndroidXchanger
AppleXchanger
GameXchanger
GamingXchanger
BlenderXchanger
UxXchanger
CookingXchanger
PhotoXchanger
StatsXchanger
MathXchanger
DiyXchanger
GisXchanger
TexXchanger
MetaXchanger
ElectronicsXchanger
StackoverflowXchanger
BitcoinXchanger
EthereumXcanger
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
0
answers
4
views
0
votes
SQL Kimball Data Warehouse ETL Create Pipeline
sql-server
database-design
data-warehouse
etl
star-schema
Updated February 07, 2019 05:06 AM
0
answers
2
views
0
votes
DB2 Database Conversion Workbench Issue
sql-server
db2
etl
Updated February 05, 2019 19:06 PM
1
answers
182
views
1
votes
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
0
answers
4
views
0
votes
Datawarehouse Staging Tables: Null or Not Null
sql-server
data-warehouse
sql-server-2017
etl
Updated January 09, 2019 19:06 PM
1
answers
16
views
0
votes
Data Warehouse Instrumentation and Metadata - Recording Business Logic Decisions
data-warehouse
etl
metadata
architecture
business-intelligence
Updated December 18, 2018 21:06 PM
0
answers
9
views
-2
votes
Tool for ETL in oracle 11g
oracle-11g
data-warehouse
etl
Updated December 10, 2018 20:06 PM
0
answers
3
views
0
votes
How to compare data between staging and operational tables?
sql-server
etl
except
Updated December 04, 2018 20:06 PM
1
answers
2306
views
1
votes
Quick way to validate two tables against each other
sql-server
sql-server-2008-r2
etl
except
Updated November 30, 2018 20:06 PM
4
answers
18429
views
11
votes
QUERY or ETL PROCESS TO INSERT DATA INTO FACT TABLES in SSMS
sql-server
ssis
ssms
etl
Updated November 27, 2018 23:06 PM
1
answers
7
views
-4
votes
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
0
answers
8914
views
3
votes
AI-proof SQL jobs
sql-server
query
data-warehouse
etl
cloud
Updated November 27, 2018 11:06 AM
0
answers
6
views
0
votes
Increase frequency of updates (ETL process) to Data Warehouse
sql-server
data-warehouse
etl
Updated November 21, 2018 03:06 AM
0
answers
5
views
0
votes
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
0
answers
6
views
1
votes
SSIS Installation on Dedicated Server
ssis
installation
etl
ssis-2016
Updated November 09, 2018 13:06 PM
0
answers
4
views
0
votes
DATA ETL methodology
mysql
database-design
etl
Updated November 07, 2018 00:06 AM
0
answers
3
views
0
votes
Efficiently bulk upsert unrelated rows
sql-server
transactional-replication
etl
upsert
table-valued-parameters
Updated November 01, 2018 20:06 PM
0
answers
8
views
1
votes
Export to EXCEL multiple excel files from multiple grids
sql-server
t-sql
ssis
etl
Updated November 01, 2018 18:06 PM
0
answers
9
views
0
votes
Database administration in "start-up" companies
sql-server
sql
etl
business-intelligence
Updated October 21, 2018 16:06 PM
0
answers
11
views
1
votes
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
0
answers
6
views
0
votes
SSIS ETL or CDC - real time DWH reporting
sql-server
sql-server-2012
data-warehouse
etl
Updated October 17, 2018 21:06 PM
1
answers
7
views
0
votes
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
1
answers
22
views
1
votes
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
0
answers
8
views
0
votes
Daily data import from private cloud database
ssis
import
etl
Updated October 05, 2018 14:06 PM
0
answers
7
views
0
votes
reseed auto_increment to specific number?
sql-server
mysql
etl
auto-increment
Updated October 02, 2018 10:06 AM
1
answers
12
views
1
votes
Can ETL access Data while Rebuild Index Operation is running
sql-server
index
sql-server-2014
etl
Updated September 23, 2018 18:06 PM
0
answers
4
views
0
votes
SSIS Package Execution Completes But Does Nothing
sql-server
sql-server-2012
ssis
etl
Updated September 20, 2018 15:06 PM
0
answers
6
views
0
votes
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
0
answers
23
views
0
votes
Handling variable fields in a CSV file with JSON?
postgresql
import
json
etl
csv
Updated August 16, 2018 19:06 PM
1
answers
8
views
2
votes
Index Maintenance for DW- DB ( ETL process )
sql-server
index-tuning
data-warehouse
etl
index-maintenance
Updated July 30, 2018 17:06 PM
0
answers
16
views
0
votes
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
0
answers
5
views
1
votes
SQL Bulk import vs SSIS in Simplicity
sql-server
sql-server-2012
ssis
etl
bulk-insert
Updated July 11, 2018 06:06 AM
0
answers
3
views
0
votes
SSIS - dynamically merging a group of files
sql-server
ssis
etl
ssis-2016
Updated May 21, 2018 14:06 PM
0
answers
5
views
1
votes
Multiple Agent Jobs Running same SSIS Package
sql-server
ssis
sql-server-agent
etl
Updated May 17, 2018 20:06 PM
0
answers
4
views
0
votes
Partial Database Migration: Dealing with CRUD Queries
ssis
migration
etl
Updated April 25, 2018 15:06 PM
0
answers
5
views
0
votes
SSISDB too large
ssis
etl
Updated April 13, 2018 19:06 PM
0
answers
6
views
0
votes
Data warehousing (ETL): Scheduled data migration from MySQL to PostgreSQL
mysql
postgresql
etl
automation
Updated April 10, 2018 08:06 AM
0
answers
6
views
0
votes
Looking to clean up this ETL code - PasteThePlan included + Bonus Architecture question
sql
execution-plan
etl
architecture
Updated April 05, 2018 18:06 PM
0
answers
2
views
0
votes
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
0
answers
4
views
0
votes
Confusion in Informix when selecting dates with JOIN
sql
etl
informix
ibm-data-studio
Updated March 31, 2018 20:06 PM
0
answers
3
views
0
votes
Single User Mode and Replication
sql-server-2014
transactional-replication
etl
Updated March 28, 2018 15:06 PM
1
answers
11
views
2
votes
Copying large amounts of data to another target tables
sql-server
migration
performance-tuning
etl
Updated March 06, 2018 18:06 PM
0
answers
11
views
0
votes
Databases Integration
database-design
etl
dblink
integration
Updated February 01, 2018 00:06 AM
0
answers
4
views
0
votes
SQL Server Shared Memory Provider Timeout
sql-server
ssis
etl
Updated January 22, 2018 15:06 PM
0
answers
9
views
0
votes
Data Warehouse: Staging Area, DWH databases and ETL tool on one server?
data-warehouse
etl
architecture
Updated January 07, 2018 17:06 PM
0
answers
4
views
0
votes
Approaches for handling nvarchar sources to data warehouse
sql-server
data-warehouse
etl
Updated December 16, 2017 01:06 AM
0
answers
3
views
0
votes
I need to generate a GUID,help
sql
ssis
etl
uuid
Updated November 30, 2017 22:06 PM
0
answers
2
views
0
votes
Restoring MSSQL back-ups to Oracle 12c
sql-server-2008
backup
oracle-12c
etl
Updated November 28, 2017 23:06 PM
0
answers
4
views
0
votes
How can I SELECT an 'instance' in PostgreSQL?
postgresql
stored-procedures
trigger
etl
change-data-capture
Updated November 22, 2017 18:06 PM
0
answers
4
views
0
votes
UPSERT or INCREMENTAL update of table but with DELETE
postgresql
etl
upsert
Updated November 15, 2017 11:06 AM
0
answers
7
views
0
votes
Showing Page 1 of 0
Query Search
Categories
ServerfaultXchanger
SuperuserXchanger
UbuntuXchanger
WebappsXchanger
WebmastersXchanger
ProgrammersXchanger
DbaXchanger
DrupalXchanger
WordpressXchanger
MagentoXchanger
JoomlaXchanger
AndroidXchanger
AppleXchanger
GameXchanger
GamingXchanger
BlenderXchanger
UxXchanger
CookingXchanger
PhotoXchanger
StatsXchanger
MathXchanger
DiyXchanger
GisXchanger
TexXchanger
MetaXchanger
ElectronicsXchanger
StackoverflowXchanger
BitcoinXchanger
EthereumXcanger