Incremental Loading

View previous topic View next topic Go down

Incremental Loading

Post  LR on Wed Sep 29, 2010 12:45 pm

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



LR

Posts : 5
Join date : 2010-08-16

View user profile

Back to top Go down

Re: Incremental Loading

Post  ngalemmo on Thu Oct 07, 2010 5:34 pm

Not sure I understand the question.

Best practice depends on what, if any, change history is needed.

As for "Which approaches cause a less impact on the presentation area (queries, reports)?" I would say, no change history is the simplest to deal with. But it doesn't matter since business requirements, not presentation conveniences, would drive the design.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum