Extracting data when there is no timestamp in the source system

DWH at 16h00
20
Feb
2010
Extracting data when there is no timestamp in the source system

Guys, what are your strategies to extract data when the source system does not have any timestamps. Is there any way to still get deltas ?

Thanks

Read more
Reply
About
This topic belongs to the forum

  • Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.

  • Numbers of topics : 1858
  • Numbers of messages : 8714
  • Numbers of users : 3801
  • Numbers of points : 1672
Similar topics
Can Data Warehouse be used as source for operational system
What are the pros and cons of using Data Warehouse (DWH) as source for an operational system? Background:- I work for a company who have now opted to use DWH to populate some of the small operational system's data base, The data in the DWH is
Extracting - separate source tables vs SQL query
Hi, I am in 2 minds on my extract process for a particular source system. The system has customer information stored in 3 tables in 3rd normal form (e.g. name in one, address in another and contact details in another). Each table has a reliable modifie
Bus Matrix - Business Process -to- Source System not 1:1?
We have a number of source systems that all do the same thing- receive loan applications. The reason for multiple systems is because some are web-based, some are for B2B, and some are legacy. So, do we list three separate Business Processes on the Bus
ETL to handle deleted reference data
Hello all, I have a situation that I am unsure how to handle and would appreciate some input. My operational system allows me to add, edit and remove customers. My source operational system also constrains me from adding a cusomter with the same nam
Non-durable natural keys
Hi all, I'm having an issue with an employee dimension whereby the typical natural key (employee id) is not durable. That being the case, and not being able to use the name as a natural key, I'm a bit stuck as to what I should use for a business key in
Forums from same category
See also
more_less
Informations

6 Replies For the topic :
"Extracting data when there is no timestamp in the source system"

This topic has been viewed 1774 times.

Last message :
20/02/2010 at 16h00 by "DWH"