ETL
Using REST webservices for ETL / Datawarehousing
Has anyone useda REST-based approach for ETL / Datawarehousing operations? In other words, invoking ETL and OLAP / Database refresh jobs through REST webservices calls:[详细]
2023-01-07 18:25 分类：问答SQL Server: unique key for batch loads
I am working on a data warehousing project where several systems are loading data into a staging area for subsequent processing.Each table has a \"loadId\" column which is a foreign key against the \"[详细]
2023-01-06 02:24 分类：问答Which is better, ETL or ELT? [closed]
Closed. This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the question so it can be answered with facts and citations by editing[详细]
2023-01-04 05:40 分类：问答Oracle-->SQL - forced conversion from non-unicode to unicode?
I have an ETL that is importing tab开发者_如何学Cles from Oracle to SQL 2008 using the OLEDB FastLoad.[详细]
2023-01-04 04:38 分类：问答discovering files in the FileSystem, through SSIS
I have a folder where files are going to be dropped for importing into my data warehouse. \\\\server\\share\\loading_area[详细]
2023-01-03 10:51 分类：问答Importing multiple file types into SSIS / mapping fields
I am working on a new Datawarehouse trying to import a number of d开发者_JAVA百科ifferent format files from a number of different providers.[详细]
2023-01-03 10:31 分类：问答SSIS XMl processing
For my job I do very big imports of (product) data. Recently we started using SSIS and it sure works better then custom .net import tools. Still after 3 projects we figured out it\'s more efficient to[详细]
2023-01-02 23:09 分类：问答Automated ETL / Database Migration Solution
I\'m looki开发者_如何学Cng for an ETL solution that we can create a configure by hand and then deploy to run autonomously. This is basic transformation, it need not be feature heavy. Key points would[详细]
2022-12-31 05:14 分类：问答How to extract data from Google Analytics and build a data warehouse (webhouse) from it?
I have click stream data such as referring URL, top landing pages, top exit pages and metrics such as page views, number开发者_Go百科 of visits, bounces all in Google Analytics. There is no database y[详细]
2022-12-30 12:30 分类：问答SSIS 2005 - How to Import a Fixed Width Flat File?
I have a flat file that looks something like this: junk I don\'t care about\\n \\n columns names\\n val1val2va开发者_如何学Gol3\\n[详细]
2022-12-30 06:34 分类：问答
加载中,请稍侯......