How are DW architects approaching automated incremental updates of a data
warehouse from the source OLTP systems for new data in both the fact table
and dimension tables? Are they using Transactional Replication into an
intermediate database? Are they utilizing DTS with Lookups? Are they
utilizing DTS with Data Driven Query tasks? Or are they utilizing ADO with
variables in Active Scripts?
Does anyone have any instruction, examples or implemenation code they could
share? This seems to be a very important piece following the construction
of a data warehouse and I'm lacking in supporting information.
Thanks to all who share their expertise
MCT, MCSD, MCSE