In my envrionment not all the tables have datetime field that
indicates when the row is created or updated. Coming up a DW project
that will be implemented I would like to ask the community what kind
of techniques they use for Incremental data loading. There are some
tables that has over 20 million rows that I don't want to do full load.

Hi

As you are on SQL 2005 you could use table partitions. Your exact solution
is very much dependent on the application and system you have for it's
design.

John

"Bulent" <bulentgucuk@gmail.com> wrote in message
news:7f32be14-e754-4379-9a28-54697308a59a@c65g2000hsa.googlegroups.com...
> In my envrionment not all the tables have datetime field that
> indicates when the row is created or updated. Coming up a DW project
> that will be implemented I would like to ask the community what kind
> of techniques they use for Incremental data loading. There are some
> tables that has over 20 million rows that I don't want to do full load.