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
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
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
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
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
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.
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
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
Goal: Fill data in the table Fact_buy. Problem: How should I make a data transaction based on the sql code below to
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
加载中,请稍侯......