Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Incremental Loading

2 posters

Go down

Incremental Loading Empty Incremental Loading

Post  LR 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

Back to top Go down

Incremental Loading Empty Re: Incremental Loading

Post  ngalemmo 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.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Back to top


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