Historical and Incremental Loading of Dimension and Fact tables

Incremental Load for fact table help

Hi All, I have a fact table which has 8 million rows now and currently gets updated on drop and rebuild basis. I will briefly describe the ETL process from our source to this fact table first. 1. I firstly incrementally load data from 8 source

Incremental Loading

Hi All, I plan to implement an own ETL tool. Which are the best practices for incremental loading (fact and dimensions)? Which approaches cause a less impact on the presentation area (queries, reports)? Thanks, Leandro

Update and deletes in incremental loading of the fact table

Dear all, I'm very new to ETL and I've been trying to incrementally load a fact table. But I have little idea about how Updates and deletes need to be managed. My business requirement wants a snapshot (eg: comparison of this month's MTD with last month

Loading a Fact Table with SCD2

I would love some design input!! I have a dimension table for Subscriber and Fact table that calculates the credits a subscriber earns based on the number of successful payments (add'l business criteria applied). Note: There is a separate fact that

FACT table Incremental load!

Hi I have huge data source (1TB), that data source table is not well designed, its primary keys are four columns which are all nvarchar! and in that source there is no date filed neither a serial or sequence #! my question, how I can implement an

Can a fact table be used as a source for populating another fact table

Scenario: There are two source tables : 1. SRC_INV_HDR (1 million rows in a year) 2. SRC_INV_DISCREPANCIES (1lac rows in a year) Landing tables in ODS : DWI_INV_HDR DWI_DISCREPANCIES Two fact tables : 1. DWB_Invoice_hdr 2.

2 fact at different granuality demanding different level of a dimension hierarchy.

Hi, Here is what i am trying to design. There is a transaction level fact table say Fact1.. One of the dimensions for this fact table is Dim1, which has hierarchy as L1>L1>R1.. leaf to root. The Leaf node (L1) of the dimension is Foreign key in the

Fact table with multiple date ?

Hi, I am modling a fact table for prisoners inscription in order to track historical changes. An admission is the hole stay comprise of one or many inscriptions usually separated by transferts between institutions. In the transactionnal system, it

Wide and large Dimension or Survey Factless Fact Table

Hi I would like some advice on this particular point. We receive responses to surveys containing hundreds of questions. Those surveys are submitted many times to about ten thousands people we follow. Their answers could change in time. Usually the

Incremental(Delta) Load Test

Hi all It is my first post in this forum, we have recently started to implement a dimensional data warehouse for our organisation and I am the main person in charge of implementing the ETL jobs. We use SAP BO DataServices as the ETL tool. My question i

10 Random Unknown Facts

Lets all get to know each other a little better! Write ten facts about yourself that others probably don't know, and lets get to know the person BEHIND the YouTube name! 1. Im very insecure about myself in real life. Whenever I appear confident it is

Stuck on "Prepare software package" MID re-flash 1.6 wmt2.1.2_105

Hello boys and girls, I have bought a generic tablet from chinavasion.com: a MID - Android 1.6 - wmt2.1.2_105 http://www.chinavasion.com/large-capacity-pmps/7-inch-android-tablet-with-wifi-and-camera/ It worked well first. Then I tried to dim the

need help getting rid of a nasty infection that has rendered my new computer essentially useless

I was informed of this site when I asked about this on yahoo answers. The person, JP, recommended I download HijackThis. The problem is I don't seem to have anyway to download anything now. Here is where I stand: First, I am currently back to using my