Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Ongoing acquisition of changed OLTP data in DW

Status
Not open for further replies.

Guest_imported

New member
Jan 1, 1970
0
I wanted some help on the folowing scenario.

A DW already exists. Data is ETL-ed from the OLTP to DW. 6 months down the lane the profile of many customers change in the OLTP owner system for customer data.

What are teh various ways to acquire this changed data into the DW.

Note(s):
* Though a DW already exists in this scenario, don't assume any hard and fast architecture - messaging or any other - for data transfers. Please discuss the solutions in different architectures.

Any help would goa long way in increasing my knowledge on DWing.

Thanks,
AmAFreshie
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top