Hi there
Is there functionality in SQL 2005 to update only new records, e.g. only records from yesterday. I've seen functionality for dimension tables to only get new records but nothing for fact tables.
Thanks
new fact records
Hot Topic
- Compact Sql Mobile 3.0 DataBase in C++/OLE DB ?
- [ URGENTlY URGENT ] PARAMETER LENGTH 1024
- Connecting to SQL 2005 server on Windows 2003
- Parameter Mapping in an Execute SQL Task
- User Instance Errors
- Connecting to SQL 2005 from a client pc
- Keep a Group Together
- OLE DB timeout processing AS Cube
- How to include SSIS into install file?
- Audit Transformation error
SQL Server
- When to create columns and metadata for custom asynchronous component output
- Report Model
- Data Source for Process Cube
- How to Select Few row data from SQL Server 2000 database
- OK button not working...
- Why is sort so slow?
- Using Guids instead of identities
- Problem scheduling a package
- Trim Strings
- Database Design Question
new fact records
batin vadim
Hacker
Not altogether sure I understand the requirement but I'll try.
Once you have your records that need to be updated (by whatever means you use to do that), have a LOOKUP component that checks the fact table to see which of those rows were loaded yesterday (or whenever).
-Jamie
Tobisen
Hi Jamie
Thanks for the reply, I want to do an iterative update of my datawarehouse add new records only rather than deleting the table and reimporting the entire table. I have read about variables etc and I thought there might be a way to query the data warehose to check the most recent record then use that to update my sql query which brings in the data. By the way I'm using ODBC connection for this.
Cheers,
Kiwi
Jeff625
Read this and try method 2:
http://www.sqlis.com/default.aspx 311
-Jamie