hanug

 Profile Answers by hanug 

• Dec 11th, 2006

 

HI:

There are two ways u have to load fact table.

1. First time load

2. Incremental load or delta load

In both cases, u have to aggregate, get the keys of the dimentional tables and load into Fact.

In case of increments, u use date value to pickup only delta data while loading into fact.

Hanu.

tannya

• Dec 15th, 2006

 

Fact tables always maintain the history records,and mostly consists of keys and measures,So after all teh dimension tables are populated,teh fact tables can be loaded.

The load is always going to be a incremental load except for the first time which is a history load.