ETL Extraction

Hi,

I am running an ETL process that uses timestamp on the source to determine the changes. We have to use this method as the source data is located on a SQL server 2005 machine.
This method will increment the timestamp when any of the rows are changed. I am only extracting data from a small number of columns within the table.
For example I need the data on col1, col2, col3, col4 only. If the data changes only in col5, the ETL process extracts the rows those rows as well. It does not do anything with it once extracted but it seems like an unnecessary action.

Is it possible to extract only the rows in which changes to the columns I want to extract have changed and ignore the rows where other columns have changed?

Many thanks
Morpheus7Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ste5anSenior DeveloperCommented:
Well, the extract process must of course extract all values, before he can determine which columns/rows have changed. Otherwise you need an change indicator in the source data and you *must* trust the source data for correct change tracking.

So in the extract phase this is pretty normal. In the transform and load steps you may skip unchanged data.

Just for curiosity: Do you mean ROWVERSION, when saying TIMESTAMP?
1

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SQL

From novice to tech pro — start learning today.