By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,779 Members | 1,078 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,779 IT Pros & Developers. It's quick & easy.

data warehouse center

P: 1
hi, i am using data warehouse center as an ETL.
I have a remote database and a local database. i have to extract data from remote and put it in local database. remote database consists of complete database which gets updated on 30th of every month. now my problem is that i want to fetch only that data into local database which is current. local database consists of a table in which last_process_date is available.

now i want a output like:
select * from [remote databse] where last_process_date = max[last_process_date];
for this i need to pass the value from local database to remote database. how is it possible?

*last_process_date is available in local database. no date is available in remote database.
Oct 30 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.