ETL
Java Desktop Application to Upload CSV Files to Database
I\'m working on desktop application (Extract Transform Load type of app) that requires uploading of large CSV files (about 6 GB) to a database using Java as front end and Oracle as a backend but I\'m[详细]
2023-04-12 07:23 分类：问答.NET ETL Process
First some background; we are developing a datawarehouse and doing some research on what tools to use for our ETL process. The team is very developer centric, everyone is knowledgeable with C#. So far[详细]
2023-04-10 03:41 分类：问答tutorials or url on how to design an etl that loads data in Dimension table in sql 2008 r2
How can design an ETL that is able to load new recordsin dimension tableand automically primary keys or surrogate keys are assigned to new record开发者_运维问答s in a dimension table. Please helpwith[详细]
2023-04-10 02:01 分类：问答Practical Implementation for Data Warehouse
Data warehousing seems to be a big trend these days, and is very interesting to me. I\'m trying to acquaint myself with its concepts, and am having a problem \"seeing the forest through the trees\" be[详细]
2023-04-09 08:40 分类：问答Data validations while transforming data in Pentaho
How do I check for foreign key validations while using Pentaho for transformation? Like I would like to transfer one table named employee from a source MySQL database to another target MySQL, and if t[详细]
2023-04-08 17:18 分类：问答ETL sync in every sixth hour
I need to make a ETL sync to add n开发者_如何学Cew data from relational database to the database DW in SSIS. It should take place in every sixth hour.[详细]
2023-04-08 14:34 分类：问答Overriding package configured variables in SSIS 2008 using DTEXEC /SET
I\'m having a problem transitioning a 2005 package to 2008 - it appears that in 2008, package variables configured to use a Configuration Filter (eg populate from [SSIS Configurations]) will not honor[详细]
2023-04-06 17:17 分类：问答Hierarchical data in ETL
I\'m new to ETL tool, but what I find out evaluation them that they all work with flat row model. I.e. if your data requires some graph object trans开发者_C百科formation (i.e. checking parent fields o[详细]
2023-04-06 08:57 分类：问答SSIS transaction from retional table to the fact_buy
Goal: Fill data in the table Fact_buy. Problem: How should I make a data transaction based on the sql code below to[详细]
2023-04-05 08:41 分类：问答Way to log data causing errors in Oracle materialized view?
We created some materialized views that ran fine against a copy of actual app data.The app does not police its own data.Since then, some of the users may have been either careless or creative in their[详细]
2023-04-04 10:16 分类：问答
加载中,请稍侯......