Regarding Reloading of Data????

[sushil353]

Hi All..

i have 6 tables.. 5 dimension table and 1 fact table.. In fact table there is huge data like for 1 hour the data in fact table is 13 million rows..

My query is....how can we make our loading such that the dimension table will be loaded for one time and i can reload (schedule) the fact table with reloading the dimension tables again and again....

Dimensions: Time, location, station, product design, operations

Fact: MFG

Thanks in advance

[brenner_martina]

Hi,

you can use partial reload, enter Replace or Add to Load-statement

Data1:
Replace Load * Fraom Table1;

means, that the table is complete replaced

Data2:
Add Load * from Table2 Where ...;

means, that the new data is added to existing table.